for a solution without the
expense (albeit small) of having to create a function.
Just wanted to confirm that I'm not missing a simpler solution (my knowledge
in terms of window functions is rather limited).
Until something better comes along, I'll implement the solution as suggested
here.
Regards
GMB
Hi all
I just want to confirm something regarding UNNEST function used with arrays.
I cannot see that it is specifically mentioned in the documentation , but
maybe because it is obvious.
Is the order of the result guaranteed to be the order of the array
I.e. is it possible that:
SELECT UNNEST(
Hi Vik
Thanks for the reply.
Can you please give me an example of how the order is specified?
I want the result of the UNNEST to be in the order of the array field
E.g.
SELECT UNNEST ( ARRAY[ 'abc' , 'ggh' , '12aa' , '444f' ] );
Should always return:
unnest
abc
ggh
12aa
444f
How
The best, which you won't
like, is to wait for 9.4 where unnest() will most likely have a WITH
ORDINALITY option and you can sort on that.
The fact that this type of thing is on the 9.4 roadmap indicates (to me, in
any case) that there are problems with the UNNEST functionality in the
gmb wrote:
Thanks for the feedback, Harald.
How about specifying different aliases to the resulting values?
This will be handy when I use the same function multiple times in the same
query.
(the function will take another input parameters used in the calculations)
E.g.:
SELECT
Pavel Stehule wrote:
npcps_201=# select * from (select 1,2,2,3) x (a,b,c,d);
That is a neat trick - one I didn't know of.
Thanks Pavel
--
View this message in context:
http://postgresql.1045698.n5.nabble.com/Usage-of-function-retruning-record-in-query-tp4549140p4552618.html
Sent from
Hi
I have a stored function returning a record consisting of two field, and
receiving as input a single identifier:
CREATE FUNCTION calcvalues(IN itemid VACHAR, OUT calcval1 NUMERIC, OUT
calcval2 NUMERIC)
RETURNS record...
Now, I want to use this function in a query as follows:
SELECT itemid,
Harald Fuchs-10 wrote:
In article 1309762075448-4549140.p...@n5.nabble.com,gmb
lt;gmbou...@gmail.comgt; writes:
SELECT itemid, (calcvalues(itemid)).* FROM itemlist
Thanks for the feedback, Harald.
How about specifying different aliases to the resulting values?
This will be handy when I use