Hi all.
Take this example from src/test/regress/sql/with.sql:
WITH RECURSIVE subdepartment(level, id, parent_department, name) AS
(
-- non recursive term
SELECT 1, * FROM department WHERE name = 'A'
UNION ALL
-- recursive term
SELECT sd.level + 1, d.*
Andreas Joseph Krogh andr...@officenet.no writes:
If I omit ORDER BY, is the output *guaranteed* (according to some
standard) to be ordered
No. It's not necessary to read any other details to answer that ...
regards, tom lane
--
Sent via pgsql-sql mailing list
I know, I know, PostgreSQL has Booleans that work very nicely.
Unfortunately, I have to create a schema that will work on Oracle as
well as PostgreSQL, by which I mean that a single set of Java/JDBC code
has to work with both databases. I have an XML meta-schema that enables
me to generate
Thanks, I have used
SELECT sequence_name FROM information_schema.sequences WHERE
sequence_catalog=? AND sequence_schema=?
and then I can use
select * from sequence-name
It seems to work :-)
Andre
Chris Browne wrote:
Andre Rothe aro...@phosco.info writes:
Where are stored the sequence