Postgres Pro
Downloads
Home   >   mailing lists

Re: Strange array_to_table / unnest result - Mailing list pgsql-general

From Johann Spies
Subject Re: Strange array_to_table / unnest result
Date
Msg-id CAGZ55DSi9ybDE_-oLz3zF78x93uNn-uQojLJj0xG+OTVt83_iQ@mail.gmail.com
Whole thread Raw
In response to Re: Strange array_to_table / unnest result  (Pavel Stehule <pavel.stehule@gmail.com>)
List pgsql-general
Tree view



Unnest is evaluated before LIMIT
You need to use derived table

postgres=# select unnest(a) from (select a from x limit 1) si

Thank you!

Regards
Johann

pgsql-general by date:

Previous
From: sudalai
Date:
Subject: Re: ERROR: missing chunk number 0 for toast value while using logical decoder.\
Next
From: Michael Paquier
Date:
Subject: Re: Re: ERROR: missing chunk number 0 for toast value while using logical decoder.\