Re: [SQL] [GENERAL] plPGSQL bug in function creation

From: "George Weaver" <georgew1(at)mts(dot)net>
To: "Richard Huxton" <dev(at)archonet(dot)com>, <newsy(at)lewczuk(dot)com>, "Lista dyskusyjna pgsql-general" <pgsql-general(at)postgresql(dot)org>, "Lista dyskusyjna pgsql-sql" <pgsql-sql(at)postgresql(dot)org>, "Lista dyskusyjna pgsql-bugs" <pgsql-bugs(at)postgresql(dot)org>
Subject: Re: [SQL] [GENERAL] plPGSQL bug in function creation
Date: 2003-09-08 12:41:30
Message-ID: 007401c37606$9f5c8d30$fd09a18e@cleartag
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs pgsql-general pgsql-sql

I had the same success using 7.3.2 with Cygwin:

e=# SELECT functest1('A','B'), functest1(null,'B'), functest2('A','B'),
functest2(null,'B');

functest1 | functest1 | functest2 | functest2
-----------+-----------+-----------+-----------
A | B | A | B
(1 row)

e=# select version();
version
----------------------------------------------------------------------------
----------
PostgreSQL 7.3.2 on i686-pc-cygwin, compiled by GCC gcc (GCC) 3.2 20020927
(prerelease)
(1 row)

George

- snip -

> Not sure whether this is because of the change 7.3.1->7.3.2 or cygwin vs
> linux. Don't have a copy of 7.3.1 to check against, sorry. Perhaps check
the
> changes list to see if it mentions something like this.
>
> --
> Richard Huxton
> Archonet Ltd
>
> ---------------------------(end of broadcast)---------------------------
> TIP 9: the planner will ignore your desire to choose an index scan if your
> joining column's datatypes do not match
>

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Dennis Gearon 2003-09-08 14:15:23 Re: [GENERAL] plPGSQL bug in function creation
Previous Message Richard Huxton 2003-09-08 12:09:16 Re: [GENERAL] plPGSQL bug in function creation

Browse pgsql-general by date

  From Date Subject
Next Message Marco Vezzoli 2003-09-08 12:49:03 compiling libpq without 'main'
Previous Message Richard Huxton 2003-09-08 12:09:16 Re: [GENERAL] plPGSQL bug in function creation

Browse pgsql-sql by date

  From Date Subject
Next Message Jomon Skariah 2003-09-08 13:44:58 Re: MINUS & ROWNUM in PostGres
Previous Message Richard Huxton 2003-09-08 12:09:16 Re: [GENERAL] plPGSQL bug in function creation