Postgres Pro
Downloads
Home   >   mailing lists

Re: select into composite type / return - Mailing list pgsql-sql

From Pavel Stehule
Subject Re: select into composite type / return
Date
Msg-id CAFj8pRCXSg73_DXwSkLJQaVeqfw32wg8eufcGyNcZEbTO7+Tvg@mail.gmail.com
Whole thread Raw
In response to Re: select into composite type / return  (Gary Stainburn <gary.stainburn@ringways.co.uk>)
List pgsql-sql
Tree view


po 22. 3. 2021 v 12:01 odesílatel Gary Stainburn <gary.stainburn@ringways.co.uk> napsal:
On 22/03/2021 10:56, Pavel Stehule wrote:
probably you can write

D := do_breakdown(...);

and it will be faster

Pavel

That also worked, which surprised me as I thought I'd already Tried that.

this way is significantly faster. Use SELECT only a) when you read from tables, b) when you work with an set of rows (using unnest function)

Pavel


Thanks.

Gary

pgsql-sql by date:

Previous
From: Gary Stainburn
Date:
Subject: Re: select into composite type / return
Next
From: Sebastien FLAESCH
Date:
Subject: Serial sequence name when table/column name in uppercase