Re: Stored procedure failure - Mailing list pgsql-general

From Michal Hlavac
Subject Re: Stored procedure failure
Date
Msg-id 412DBA1D.9090504@medium13.sk
Whole thread Raw
In response to Re: Stored procedure failure  (Richard Huxton <dev@archonet.com>)
Responses Re: ltree bug handling nulls (was Stored procedure failure)
List pgsql-general
Richard Huxton wrote:

>
> Looking at the 8.0beta source, the functions (...ltree_isparent) are all
> marked strict so they should just return null on a null parameter.
>
> What happens if you set my_path to some non-null but un-matched value
> before the problem line?
>

When my_path have non-null value, everything is OK...

I don't understand why one null value would crash the server???

--

[ miso hlavac ][ hlavki@medium13.sk ][ http://www.medium13.sk ]
[ icq:94900232 ][ callto://hlavki ]

pgsql-general by date:

Previous
From: Michal Hlavac
Date:
Subject: Re: Stored procedure failure
Next
From: Daniel Schuchardt
Date:
Subject: Trigger question