Gordon Clarke <[EMAIL PROTECTED]> writes:
> Now if I try to do the same thing but via my function,
> SELECT insert_row(1235,null,100);
> I get the following error
> ERROR: typeidTypeRelid: Invalid type - oid = 0
> Why wont the function allow me to pass a 'null' parm?
You're running
I want to be able to pass NULL as a parameter to a function I've defined,
but I'm not allowed to do it. I believe this is a bug.
The example follows:
CREATE TABLE test_func(
func_sun int4,
surname varchar(30),
value int2NOT NULL,
CONS
On Fri, Jun 16, 2000 at 10:56:04AM +0200, Gerhard Dieringer wrote:
> > Yes this would work nicely but if I need to add more conditional clauses
> > I have to duplicate them in the main SELECT and in the sub-SELECT:
> >
> > SELECT title,stopdate
> > FROM auction
> > WHERE stopdate = (SELECT max(sto
Louis-David Mitterrand - [EMAIL PROTECTED] - http://www.apartia.fr wrote:
> ...
> Yes this would work nicely but if I need to add more conditional clauses
> I have to duplicate them in the main SELECT and in the sub-SELECT:
>
> SELECT title,max(stopdate)
> FROM auction
> WHERE stopdate = (SELECT
On Fri, Jun 16, 2000 at 09:28:27AM +0200, Gerhard Dieringer wrote:
> > I am trying to return the most recently updated record from a table:
> >
> > SELECT max(stopdate) FROM auction;
> >
> > and this works but only returns the timestamp, however if I try to get
> > another column with the aggregat
Louis-David Mitterrand - [EMAIL PROTECTED] - http://www.apartia.fr wrote:
> Hello,
>
> I am trying to return the most recently updated record from a table:
>
> SELECT max(stopdate) FROM auction;
>
> and this works but only returns the timestamp, however if I try to get
> another column with the
