Hello All:
I have a simple issue.
Within my table there is a field DESCRIPTION that I would like to parse
and split out into other fields.
Within DESCRIPTION there are spaces that separate the data items.
String_to_array(description, ' ') does the job very well.
I need something like
Kevin Duffy wrote:
Within my table there is a field DESCRIPTION that I would like to parse
and split out into other fields.
Within DESCRIPTION there are spaces that separate the data items.
String_to_array(description, ‘ ‘) does the job very well.
I need something like this to work.
-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Frank Bax
Sent: Friday, September 05, 2008 4:07 PM
Cc: pgsql-sql@postgresql.org
Subject: Re: [SQL] variables with SELECT statement
Kevin Duffy wrote:
Within my table there is a field DESCRIPTION that I would like to
parse
Kevin Duffy wrote:
Noticed that string_to_array does not handle double spaces very well.
If there are double space between the tokens, there is (empty string)
in the array returned. Not exactly what I expected.
Try regexp_replace
, September 05, 2008 4:47 PM
To: Kevin Duffy
Subject: Re: [SQL] variables with SELECT statement
2008/9/5, Kevin Duffy [EMAIL PROTECTED]:
OK that is a syntax I have never seen. But correct we are getting
close.
Noticed that string_to_array does not handle double spaces very well.
If there are double
Kevin Duffy wrote:
Just testing the regexp_string_to_array
This SQL
select description, regexp_string_to_array(description::text , E'\\s+' )
as optdesc, securitytype
from xx where type = 'B' order by 1
produced this error:
ERROR: function regexp_string_to_array(text, text) does
Frank Bax [EMAIL PROTECTED] writes:
Kevin Duffy wrote:
ERROR: function regexp_string_to_array(text, text) does not exist
Are you running 8.3?
Also, it's regexp_split_to_array ...
regards, tom lane
--
Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
To make
No looks like I have 8.2
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Frank Bax
Sent: Friday, September 05, 2008 5:13 PM
Cc: pgsql-sql@postgresql.org
Subject: Re: [SQL] variables with SELECT statement
Kevin Duffy wrote:
Just testing
Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Tom Lane
Sent: Friday, September 05, 2008 5:27 PM
To: Frank Bax
Cc: pgsql-sql@postgresql.org
Subject: Re: [SQL] variables with SELECT statement
Frank Bax [EMAIL PROTECTED] writes:
Kevin Duffy wrote:
ERROR: function
On Fri, Sep 5, 2008 at 3:28 PM, Kevin Duffy [EMAIL PROTECTED] wrote:
No looks like I have 8.2
I can attest that all of 8.3's performance improvements as well all of
the really useful new functions like the one mentioned here make it
well worth the effort to upgrade. I haven't been as excited
:[EMAIL PROTECTED]
Sent: Friday, September 05, 2008 5:35 PM
To: Kevin Duffy
Cc: pgsql-sql@postgresql.org; Frank Bax
Subject: Re: [SQL] variables with SELECT statement
On Fri, Sep 5, 2008 at 3:28 PM, Kevin Duffy [EMAIL PROTECTED]
wrote:
No looks like I have 8.2
I can attest that all of 8.3's
Kevin Duffy wrote:
No looks like I have 8.2
This works on 8.2:
String_to_array(regexp_replace(description,E'\\s+',' ','g'),' ')
--
Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-sql
I'm trying to declare a variable in PostgreSQL, so I can save some values in
it. After, I want to calculate with this variable.
For example:
declare vp integer;
select price into :vp from article where anr = 1;
vp := vp + 1;
update article set price = :vp where anr = 1;
AFAIK, you can
Hi
I'm trying to declare a variable in PostgreSQL, so I can save some values in
it. After, I want to calculate with this variable.
For example:
declare vp integer;
select price into :vp from article where anr = 1;
vp := vp + 1;
update article set price = :vp where anr = 1;
Is there a
and constructions is
available in FUNCTIONS. PL/pgSQL, PL/TCL, PL/Perl ... take your pick.
For the raw command-line SQL, variables, constants, and other procedural
language elements are not appropriate. This is best done in procedures,
functions, and middleware.
Of course, it is an Open-Source project
I would really like a feature :)
I do not know whether it is part of the SQL standard.
Variables...
e.g.
CREATE VARIABLE foobar INTEGER DEFAULT 1 NOT NULL;
SELECT * FROM thebar WHERE id = foobar;
CREATE TEMPORARY VARIABLE...
CREATE CONSTANT
Basically all the functionality from the
what im trying to do is have a Sum of a colum.. as it goes forwards
I don't think this is what you want, but I suppose it might help
Table= simple
+--+--+-
--+
| Field | Type
what im trying to do is have a Sum of a colum.. as it goes forwards with the
cursor..
like so:
Price|Sum
5|5
4|9
10|19
2|21
7|28
I think what you mean is called running sum, I had the same problem
before, and I found no other solution than creating a column for it,
and calculating its
18 matches
Mail list logo