Re: Why I cannot call a function from within an SQL function? - Mailing list pgsql-general

From Eus
Subject Re: Why I cannot call a function from within an SQL function?
Date
Msg-id 236823.25869.qm@web37602.mail.mud.yahoo.com
Whole thread Raw
In response to Why I cannot call a function from within an SQL function?  (Eus <eus@member.fsf.org>)
Responses Re: Why I cannot call a function from within an SQL function?
List pgsql-general
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@member.fsf.org> 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
computingdevices. 

Join free software movement today! It is free as in freedom, not as in free beer!

Join: http://www.fsf.org/jf?referrer=4445




pgsql-general by date:

Previous
From: Eus
Date:
Subject: Why I cannot call a function from within an SQL function?
Next
From: "A. Kretschmer"
Date:
Subject: Re: Why I cannot call a function from within an SQL function?