Re: Order by parameter inside pgsql function ignored - Mailing list pgsql-general

In response to Anton Marchenkov :
> Hi!
>
> I'm trying to use the order by parameter inside a function, but it is
> ignored. Any ideas why? And how can I sort by external parameters inside
> pgsql function?

You an use dynamic SQL with EXECUTE, for instance:

create or replace function my_order (var_order text) ... as $$
declare
  my_sql text;
begin
  ...
  my_sql := 'select ... from table order by ' || var_order';
  execute my_sql;
  ...


Regards, Andreas
--
Andreas Kretschmer
Kontakt:  Heynitz: 035242/47150,   D1: 0160/7141639 (mehr: -> Header)
GnuPG-ID:   0x3FFF606C, privat 0x7F4584DA   http://wwwkeys.de.pgp.net