Use dollar quoting around your fiction body I'd double up on the
single quotes around the dash
Sent from my iPhone
On Feb 20, 2009, at 8:14 AM, Eus <eus@xxxxxxxxxxxxxx> wrote:
Hi Ho!
Sorry, let me revise the query a bit. I copied and pasted the
original one from another big query.
--- On Fri, 2/20/09, Eus <eus@xxxxxxxxxxxxxx> wrote:
The following query works well:
select count (*)
from item_audit as ia
where audit_ts >= '2008-05-30 00:00:00'
and audit_ts <= '2008-10-30 00:00:00'
and 'wst' != (select split_part(category, '-', 2)
from description
where split_part(category, '-', 1) = 'item'
and shorthand = ia.status
)
But, when I transform it into the following SQL function,
the function cannot be created barking:
ERROR: syntax error at or near "-"
LINE 6: and $1 != (select split_part(category,
'-', 2)"
create or replace function get_I(text, timestamp,
timestamp) returns bigint as
'select count (*)
from item_audit as ia
where audit_ts >= $2
and audit_ts <= $3
and $1 != (select split_part(category, '-',
2)
from description
where split_part(category, '-',
1) = 'item'
and shorthand = ia.status
)
' language sql;
What's wrong?
Thank you.
Best regards,
Eus (FSF member #4445)
In this digital era, where computing technology is pervasive, your
freedom depends on the software controlling those computing devices.
Join free software movement today! It is free as in freedom, not as
in free beer!
Join: http://www.fsf.org/jf?referrer=4445
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
