Re: Q: unexpected result from SRF in SQL

From: Ian Barwick <barwick(at)gmx(dot)net>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: pgsql-hackers <pgsql-hackers(at)postgresql(dot)org>, Joe Conway <mail(at)joeconway(dot)com>
Subject: Re: Q: unexpected result from SRF in SQL
Date: 2002-05-26 17:04:04
Message-ID: 200205261904.04964.barwick@gmx.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Sunday 26 May 2002 17:58, Tom Lane wrote:
(...)
> If anyone does someday resurrect fjoin-like functionality, a reasonable
> SQL-style syntax for invoking it would be
>
> SELECT (bar(1)).*;
>
> which would still leave us wanting to raise an error if you just write
> "SELECT bar(1)".

The reason why I posted the question is that I had defined a function
that should have worked, but kept giving me back strange numbers,
so I spent a whole five minutes trying to debug the function before
I realised I was calling it in the wrong way (doh). An error here would
be a Good Idea, IMHO.

Ian Barwick

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Ian Barwick 2002-05-26 17:58:19 Re: Schemas: status report, call for developers
Previous Message Olivier PRENANT 2002-05-26 16:55:21 WAL FILES