Re: [SQL] NO DATA FOUND Exception

2007-06-25 Thread Michael Glaesemann
[Please create a new message to post about a new topic, rather than replying to and changing the subject of a previous message. This will allow mail clients which understand the References: header to properly thread replies.] On Jun 25, 2007, at 14:20 , Fernando Hevia wrote: Is something l

Re: [SQL] NO DATA FOUND Exception

2007-06-25 Thread Fernando Hevia
>On Mon, Jun 25, 2007 at 04:20:37PM -0300, Fernando Hevia wrote: >> when <> then return variable; >> when <> then <> ; >> when <> then <> ; > >Check out the FOUND variable in the documentation for the first two, >and the "trapping errors" section for the latter. > >Andrew Sullivan | [EMAIL

Re: [SQL] NO DATA FOUND Exception

2007-06-25 Thread Andrew Sullivan
On Mon, Jun 25, 2007 at 04:20:37PM -0300, Fernando Hevia wrote: > when <> then return variable; > when <> then <> ; > when <> then <> ; Check out the FOUND variable in the documentation for the first two, and the "trapping errors" section for the latter. A -- Andrew Sullivan | [EMAIL PRO

[SQL] NO DATA FOUND Exception

2007-06-25 Thread Fernando Hevia
Hi. Im taking my first steps with plpgsql. I want my function to react to the result of a query in the following way: begin select column into variable from table where condition; exception when <> then return variable; when <> then <> ; when <> then <> ; end ; Is something like this pos

Re: [SQL] [GENERAL] yet another simple SQL question

2007-06-25 Thread Erik Jones
On Jun 25, 2007, at 12:44 PM, Joshua wrote: Ok, You guys must be getting sick of these newbie questions, but I can't resist since I am learning a lot from these email lists and getting results quick! Thanks to everyone for their contributions. Here is my questions I have a column tha

Re: [SQL] yet another simple SQL question

2007-06-25 Thread Ragnar
On mán, 2007-06-25 at 12:44 -0500, Joshua wrote: > I have a column that looks like this > > firstname > - > John B > Mark A > Jennifer D > > Basically I have the first name followed by a middle initial. Is there a > quick command I can run to strip the middle initial? how about:

Re: [SQL] yet another simple SQL question

2007-06-25 Thread A. Kretschmer
am Mon, dem 25.06.2007, um 12:44:25 -0500 mailte Joshua folgendes: > Ok, > > You guys must be getting sick of these newbie questions, but I can't > resist since I am learning a lot from these email lists and getting > results quick! Thanks to everyone for their contributions. > > Here is my qu

Re: [SQL] yet another simple SQL question

2007-06-25 Thread manchicken
On Monday 25 June 2007 12:44:25 Joshua wrote: > Ok, > > You guys must be getting sick of these newbie questions, but I can't > resist since I am learning a lot from these email lists and getting > results quick! Thanks to everyone for their contributions. > > Here is my questions > > I have a c

[SQL] yet another simple SQL question

2007-06-25 Thread Joshua
Ok, You guys must be getting sick of these newbie questions, but I can't resist since I am learning a lot from these email lists and getting results quick! Thanks to everyone for their contributions. Here is my questions I have a column that looks like this firstname - J

Re: [SQL] another simple SQL question

2007-06-25 Thread manchicken
On Monday 25 June 2007 10:28:40 Joshua wrote: > Ok here is another simple question from a novice > > Here is what my table looks like > > firstname lastname fullname > -- -- --- > smith, john >

Re: [SQL] simple SQL question

2007-06-25 Thread manchicken
On Monday 25 June 2007 10:19:49 Fernando Hevia wrote: > > > I have a column with the following values (example below) > > > > > > 5673 > > > 4731 > > > 4462 > > > 5422 > > > 756 > > > 3060 > > > > > > I want the column to display the numbers as follows: > > > > > > 56.73 > > > 47.31 > > > 44.62 > >

Re: [SQL] another simple SQL question

2007-06-25 Thread Jean-David Beyer
Joshua wrote: > Ok here is another simple question from a novice > > Here is what my table looks like > > firstname lastname fullname > -- -- --- > smith, john >

Re: [SQL] simple SQL question

2007-06-25 Thread Ireneusz Pluta
Joshua napisał(a): I have a column with the following values (example below) 5673 4731 4462 5422 756 3060 I want the column to display the numbers as follows: 56.73 47.31 44.62 54.22 7.56 30.60 I have been playing around with string functions but cannot seem to figure out a quick solution.

[SQL] another simple SQL question

2007-06-25 Thread Joshua
Ok here is another simple question from a novice Here is what my table looks like firstname lastname fullname -- -- --- smith, john green, susan

Re: [SQL] simple SQL question

2007-06-25 Thread Fernando Hevia
> > I have a column with the following values (example below) > > > > 5673 > > 4731 > > 4462 > > 5422 > > 756 > > 3060 > > > > I want the column to display the numbers as follows: > > > > 56.73 > > 47.31 > > 44.62 > > 54.22 > > 7.56 > > 30.60 > > > > I have been playing around with string functions

Re: [SQL] simple SQL question

2007-06-25 Thread manchicken
On Monday 25 June 2007 09:38:39 Milen A. Radev wrote: > Joshua написа: > > I have a column with the following values (example below) > > > > 5673 > > 4731 > > 4462 > > 5422 > > 756 > > 3060 > > > > I want the column to display the numbers as follows: > > > > 56.73 > > 47.31 > > 44.62 > > 54.22 > >

Re: [SQL] simple SQL question

2007-06-25 Thread Milen A. Radev
Joshua написа: > I have a column with the following values (example below) > > 5673 > 4731 > 4462 > 5422 > 756 > 3060 > > I want the column to display the numbers as follows: > > 56.73 > 47.31 > 44.62 > 54.22 > 7.56 > 30.60 > > I have been playing around with string functions but cannot seem to

Re: [SQL] simple SQL question

2007-06-25 Thread Rodrigo De León
On 6/25/07, Joshua <[EMAIL PROTECTED]> wrote: I have a column with the following values (example below) 5673 4731 4462 5422 756 3060 I want the column to display the numbers as follows: 56.73 47.31 44.62 54.22 7.56 30.60 I have been playing around with string functions but cannot seem to figu

[SQL] simple SQL question

2007-06-25 Thread Joshua
I have a column with the following values (example below) 5673 4731 4462 5422 756 3060 I want the column to display the numbers as follows: 56.73 47.31 44.62 54.22 7.56 30.60 I have been playing around with string functions but cannot seem to figure out a quick solution. Does anyone have any