[SQL] Order of WITH RECURSIVE output

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.*

Re: [SQL] Order of WITH RECURSIVE output

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