Re: [SQL] aggregate reverse
Yes, you got me well. That's exactly what I was trying to achieve. Thank
you.
2008/2/1, Pavel Stehule <[EMAIL PROTECTED]>:
>
> Hello
>
> I am not sure if I understand well.
>
> On 01/02/2008, Marcin Krawczyk <[EMAIL PROTECTED]> wrote:
> > Hi all. I wolud like to know whether it is possible to reverse the
> behaviour
> > of an aggregate? Say I have a string '1,2,3,4'. Is there a way to split
> > those values to records?
>
> create or replace function unpack(anyarray)
> returns setof anyelement as $$
> select $1[i]
>from generate_series(array_lower($1,1), array_upper($1,1)) g(i)
> $$ language sql immutable;
>
> select * from unpack(string_to_array('1,2,3,4',','));
> unpack
>
> 1
> 2
> 3
> 4
> (4 rows)
>
> Regards
> Pavel
>
>
> >
> > Regards and thanks in advance.
> > mk
> >
>
[SQL] can a insert with a returning clause be subquery ?
I am trying to accomplish this:
update p2user.party set ADDR_KEY =
(insert into p2user.address ( street_no, street_name)
values ('22', 'Geek St.')
returning addr_key )
where party_key = 22 ;
But I am getting error:
ERROR: syntax error at or near "into"
LINE 1: update p2user.party set ADDR_KEY = (insert into p2user.addre...
^(is actually under the
"into")
The insert by itself works fine and returns a valid integer.
I know I could do this easily with a stored proc,
but it seems like an obvious use of the returning clause
Am I missing some syntax error
--
View this message in context:
http://www.nabble.com/can-a-insert-with-a-returning-clause-be-subquery---tp15248628p15248628.html
Sent from the PostgreSQL - sql mailing list archive at Nabble.com.
---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster
Re: [SQL] can a insert with a returning clause be subquery ?
On Feb 2, 2008 6:22 PM, chrisj <[EMAIL PROTECTED]> wrote: > I know I could do this easily with a stored proc, > but it seems like an obvious use of the returning clause > > Am I missing some syntax error Nope, you're not missing anything. When I initially wrote this for Postgres, it didn't support all cases; including the one you're running into. It's not extremely difficult to extend, but as there are so few people asking for this functionality, no one has found it important enough to warrant extension. Perhaps I'll get to it for 8.4. -- Jonah H. Harris, Sr. Software Architect | phone: 732.331.1324 EnterpriseDB Corporation| fax: 732.331.1301 499 Thornall Street, 2nd Floor | [EMAIL PROTECTED] Edison, NJ 08837| http://www.enterprisedb.com/ ---(end of broadcast)--- TIP 4: Have you searched our list archives? http://archives.postgresql.org
Re: [SQL] can a insert with a returning clause be subquery ?
On Saturday 02 February 2008 4:12 pm, Jonah H. Harris wrote: > On Feb 2, 2008 6:22 PM, chrisj <[EMAIL PROTECTED]> wrote: > > I know I could do this easily with a stored proc, > > but it seems like an obvious use of the returning clause > > > > Am I missing some syntax error > > Nope, you're not missing anything. When I initially wrote this for > Postgres, it didn't support all cases; including the one you're > running into. It's not extremely difficult to extend, but as there > are so few people asking for this functionality, no one has found it > important enough to warrant extension. Perhaps I'll get to it for > 8.4. Would this be a variation of this item from the TODO: * Allow INSERT/UPDATE ... RETURNING inside a SELECT 'FROM' clause http://archives.postgresql.org/pgsql-general/2006-09/msg00803.php http://archives.postgresql.org/pgsql-hackers/2006-10/msg00693.php -- Adrian Klaver [EMAIL PROTECTED] ---(end of broadcast)--- TIP 7: You can help support the PostgreSQL project by donating at http://www.postgresql.org/about/donate
Re: [SQL] can a insert with a returning clause be subquery ?
On Feb 2, 2008 7:40 PM, Adrian Klaver <[EMAIL PROTECTED]> wrote: > Would this be a variation of this item from the TODO: > > * Allow INSERT/UPDATE ... RETURNING inside a SELECT 'FROM' clause Exactly. -- Jonah H. Harris, Sr. Software Architect | phone: 732.331.1324 EnterpriseDB Corporation| fax: 732.331.1301 499 Thornall Street, 2nd Floor | [EMAIL PROTECTED] Edison, NJ 08837| http://www.enterprisedb.com/ ---(end of broadcast)--- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
