| From: | Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com> |
|---|---|
| To: | Alban Hertroys <dalroi(at)solfertje(dot)student(dot)utwente(dot)nl> |
| Cc: | Jon Smark <jon(dot)smark(at)yahoo(dot)com>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Record with a field consisting of table rows |
| Date: | 2011-01-13 19:58:40 |
| Message-ID: | AANLkTinqVcyYNR8u3J+GR6HqVmmgLZvyMMzcQr2fj7gd@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
2011/1/13 Alban Hertroys <dalroi(at)solfertje(dot)student(dot)utwente(dot)nl>:
> On 13 Jan 2011, at 20:21, Pavel Stehule wrote:
>
>>> I'm not sure what you mean here, Postgres certainly _does_ support set-returning functions. Maybe you were referring to something in the particular context of the problem the OP is trying to solve?
>>>
>>
>> The name of feature "SET RETURNED FUNC" doesn't mean so PostgreSQL
>> supports SET type in ANSI SQL sense.
>
>
> I think this is getting off topic, but I don't understand what you're trying to say here. That's probably partially due to your odd usage of the word "so" - I think you mean to use it as "that" (which it doesn't mean), and not as "because" (which its meaning is much closer to).
> You might also want to elaborate a bit more so that people have enough context to work around your grammar ;)
>
> Anyway, are you saying:
> 1. PostgreSQL doesn't support SRF's (It does though)? Or that,
> 2. ANSI SQL doesn't support SRF's? Or that
> 3. PostgreSQL's implementation of SRF's is not compatible with the ANSI SQL definition?
>
sorry, my English isn't good. A problem is in meaning of keyword
"SET". ANSI SQL knows a datatype "SET". This datatype isn't supported
by pg. A SRF functions are called table functions in ANSI SQL. But I
can be messed
Pavel
> Or something entirely different?
>
> Alban Hertroys
>
> --
> If you can't see the forest for the trees,
> cut the trees and you'll see there is no forest.
>
>
> !DSPAM:1030,4d2f54a811877157859450!
>
>
>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Håvard Wahl Kongsgård | 2011-01-13 20:51:42 | Re: Performance on multiple OR conditions inside () |
| Previous Message | Alban Hertroys | 2011-01-13 19:38:10 | Re: Record with a field consisting of table rows |