Re: [SQL] default value for select?

2005-05-09 Thread Philip Hallstrom
I want to update a column in myTable. The value this column is set to depends on a nested select statement which sometimes returns 0 rows instead of 1. This is a problem since the column I'm trying to update is set to refuse nulls. Here's a sample: update myTable set myColumn = (Select altColum

Re: [SQL] default value for select?

2005-05-09 Thread Keith Worthington
On Mon, 09 May 2005 12:57:41 -0400, Mark Fenbers wrote > I want to update a column in myTable. The value this column is set > todepends on a nested select statement which sometimes returns 0 > rowsinstead of 1. This is a problem since the column I'm trying to > updateis set to refuse nulls. Here

Re: [SQL] default value for select?

2005-05-09 Thread Tony Wasson
On 5/9/05, Mark Fenbers <[EMAIL PROTECTED]> wrote: > I want to update a column in myTable. The value this column is set to > depends on a nested select statement which sometimes returns 0 rows instead > of 1. This is a problem since the column I'm trying to update is set to > refuse nulls. Here

[SQL] default value for select?

2005-05-09 Thread Mark Fenbers
I want to update a column in myTable.  The value this column is set to depends on a nested select statement which sometimes returns 0 rows instead of 1.  This is a problem since the column I'm trying to update is set to refuse nulls.  Here's a sample: update myTable set myColumn = (Select altC

Re: [SQL] diff value retuns, debug mode and play mode

2005-05-09 Thread AL� �EL�K
it is about null problem declare res numeric(15,2); _pida integer[4]; < Problem is here must be ---> pida integer[4]='{}'; _pid integer; _rec record; .. "ALÝ ÇELÝK" <[EMAIL PROTECTED]>, haber iletisinde þunlarý yazdý:[EMAIL PROTECTED] > > I have a