[SQL] Procedures cannot take more than 16 arguments

[Andrey]

Good day.
Does anyone know the way of sending more than 16 
parameters to function?
 
Best regards.
Andrey

[SQL] function

[Andrey]

Hi.
Does anyone know how I can declaration internal variable in 
function( SQL language ), and can I use "if" - operation, such as 
if( $1 <> $2 )
 
Best regards
Andrey
 

[SQL] maintain number in variable

[Andrey]

Can I maintain id in variable such 
as:

CREATE FUNCTION function1() RETURNS int4AS '   $var = 
select nextval(''shipment_gen'');   select $var;'LANGUAGE 
'sql'
 
Andrey

[SQL] hierar questions

[Andrey]

Good day!
Does any one know how I can create hierar request to 
db.
May be, it possible through self extracted 
function.
 
Best regards
Andrey

[SQL] Table name as a variable in SELECT query

[Andrey Fokin]

Hi,
please advise is possible in SELECT query use variable as a table name?

I would like to have  for example something like:

CREATE OR REPLACE FUNCTION test_name (tb varchar) RETURNS int AS  $$

DECLARE 

 ..

BEGIN
SELECT * FROM $1;


Will be grateful for any idea about.

 

Best regards
Andrey  

-- 
Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-sql