[GENERAL] Calling overloaded function with NULL argument

, behaviour and raise an exception ERROR: FUNCTION foo(unknown) IS NOT UNIQUE. Is there an explanation or is this a bug? I've tested this on PG 8.3.1 and 8.2.4, see http://pgsql.privatepaste.com/2bCQg0FEPX Best regards, Patryk Kordylewski -- Sent via pgsql-general mailing list (pgsql-general

Re: [GENERAL] ERROR: table row type and query-specified row type do not match

Hi Tom, we are running PostgreSQL 8.2.4. Tom Lane wrote: Patryk Kordylewski [EMAIL PROTECTED] writes: can someone help/explain me why i get this error when i try to make an update on that view? It seems that something is wrong with the subselect. http://fooby.imosnet.de/error.txt AFAICT

Re: [GENERAL] ERROR: table row type and query-specified row type do not match

Patryk Kordylewski wrote: Hi Tom, we are running PostgreSQL 8.2.4. Tom Lane wrote: Patryk Kordylewski [EMAIL PROTECTED] writes: can someone help/explain me why i get this error when i try to make an update on that view? It seems that something is wrong with the subselect. http

Re: [GENERAL] ERROR: table row type and query-specified row type do not match

Patryk Kordylewski wrote: I made a test-case which is not working for me. Perhaps something wrong with the SELECT DISTINCT ON () syntax when i specify more then 1 column? At first this was working when i specified only one column in the SELECT DISTINCT ON-clause, then i inserted a dummy

[GENERAL] ERROR: table row type and query-specified row type do not match

Hi, can someone help/explain me why i get this error when i try to make an update on that view? It seems that something is wrong with the subselect. http://fooby.imosnet.de/error.txt Thanks, Patryk ---(end of broadcast)--- TIP 1: if