SELECT 'test' FROM
SELECT 'test' FROM generate_series(1,10);Sorry, thought faster than I could type :)-Mike
If you're control is that simple, you can write similar statements in pure SQL:
RDM=# for i in 1 .. 10 loopRDM-# select "test"RDM-# end loop;ERROR: syntax error at or near "for" at character 1LINE 1: for i in 1 .. 10 loop
SELECT 'test' FROM
RDM=# if exits ( select * from testtable)RDM-# thenRDM-#
am 16.05.2006, um 21:51:45 -0400 mailte Jay Chiu folgendes:
> Can someone tell me how to use if/for in psql? The document
In plain SQL isn't if, then, else and so on.
> shows the control structures in the PL/pgSQL section. Must I use
> if/for inside some procedure/function?
Yes.
HTH, Andreas
Hello,
I am new to PostgreSQL and want to use the IF-THEN; LOOP
statements in my SQL command file. Thus I may use psql -f cfile
to exceute.
However I always got syntax error on if/for in psql. For
example:
RDM=# for i in 1 .. 10 loop
RDM-# select "test"
RDM-# end loop;
ERROR: syntax error at or
