Fatal error: Sql-error-satus: PGSQL_EMPTY_QUERY
SQL: SELECT hdsacms.getWebPagePrepared($dn40754$/page/home$dn40754$) AS functionname LIMIT 1;;
ERROR: syntax error at or near "COALESCE"
LINE 3: COALESCE(NULLIF(regexp_replace($2, '^\/?pag...
^
QUERY: PREPARE getPage2(text,text, text, text, text, text) AS WITH match(sfilename, sfull) AS (
SELECT '%'||regexp_replace($2, '^\/?page(:?\/.*)?\/', '')
COALESCE(NULLIF(regexp_replace($2, '^\/?page\/', ''), ''), '/') )
SELECT 'page/'||pathname AS pathname,
url AS filename,
title,
description,
keywords,
contenthtml,
changedate,
EXTRACT(EPOCH FROM changedate) AS epochchangedate
FROM web.vPublished AS c,
match as m
WHERE NULLIF(c.publish, 0) IS NOT NULL
AND (URL LIKE sfull
OR (URL LIKE sfilename AND URL NOT IN (SELECT URL FROM web.vPublished)))
ORDER BY contentid LIMIT 1
CONTEXT: PL/pgSQL function hdsacms.getwebpageprepared(text) line 19 at EXECUTE
in /opt/dn2.dev/includes/gdbi/Postgres.inc.php on line 387