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
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
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
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
> >
> > 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
Ok here is another simple question from a novice
Here is what my table looks like
firstname lastname fullname
-- -- ---
smith, john
green, susan
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.
Joshua wrote:
> Ok here is another simple question from a novice
>
> Here is what my table looks like
>
> firstname lastname fullname
> -- -- ---
> smith, john
>
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
> >
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
>
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
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
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
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:
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
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
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
>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
[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
19 matches
Mail list logo
