Search
 
SCRIPT & CODE EXAMPLE
 
CODE EXAMPLE FOR SQL

postgres select from values

=> SELECT * FROM (VALUES (1, 'one'), (2, 'two'), (3, 'three')) AS t (num,letter);
 num | letter
-----+--------
   1 | one
   2 | two
   3 | three
(3 rows)
Source by www.postgresql.org #
 
PREVIOUS NEXT
Tagged: #postgres #select #values
ADD COMMENT
Topic
Name
6+8 =