am Thu, dem 12.04.2007, um 15:44:19 -0700 mailte Karthikeyan Sundaram
folgendes:
> Hi Gurus,
>
> I tried a plpgsql block from the php.
>
> example
>
> a='begin
> insert into table a values ();
> insert into table b values ()
> insert into table c values
Andrew Sullivan wrote:
On Wed, Apr 11, 2007 at 10:23:34PM +0800, John Summerfield wrote:
Each row's identified by a key, and the key doesn't change.
That doesn't matter.
ADABAS would put the updated record right back where it came from, it
That isn't how PostgreSQL works.
I'm having
This may best be asked in the admin group - please don't cross-post. Let's
keep all further discussion in the admin group.
A good starting place for you would be the PostgreSQL manual, specifically
the chapter called "High Availability":
http://www.postgresql.org/docs/current/interactive/high-
Hi Team,
We are using Postgres 8.1.0 and in the plans to migrate to 8.2.3. Ours is
a OLTP application. Publishers, advertisers and consumers use our system world
wide. Right now it's not a very big database. But we are expanding our
operations to Europe and US where we are expecting a
Hi Gurus,
I tried a plpgsql block from the php.
example
a='begin
insert into table a values ();
insert into table b values ()
insert into table c values (...)
select into p_var ... from table where condtion
update a set column = where conditio
test=*# select regexp_replace(regexp_replace('The blue fox\'s fur.', ' ', '-',
'g'), '\\.', '');
regexp_replace
The-blue-fox's-fur
(1 row)
Andreas
Thanks for the input.
I came up with this:
REPLACE(regexp_replace('The blue fox\'s fur', '[[:punct:]]', ''), ' ',
The following construct does what I need but is there a better way of
expressing this?
select * from
(
SELECT DISTINCT
section.section_pk
FROM ITEM
LEFT JOIN product product ON Item.product_fk = product.product_pk
LEFT JOIN section section ON product.section_fk = section.section_pk
WHERE i
Try either
- defining the field as: crc character varying(255)
- rewrite your select as: Select * from base.points where "CRC" =
'e19e26330a0db2f2435106b16623fa82';
>>> <[EMAIL PROTECTED]> 2007-04-12 14:23 >>>
Hi list,
I have a table with many fields and the latest field is:
"CRC" character var
On Thu, Apr 12, 2007 at 09:23:39AM -0300, [EMAIL PROTECTED] wrote:
>
> "CRC" character varying(255),
^
> Select * from base.points where crc = 'e19e26330a0db2f2435106b16623fa82'
^^^
"CRC" != crc. You need to spell the column name correctly. Or don't
quot
am Thu, dem 12.04.2007, um 9:23:39 -0300 mailte [EMAIL PROTECTED] folgendes:
> Hi list,
>
> I have a table with many fields and the latest field is:
>
> "CRC" character varying(255),
You have created a field called "CRC", with upper-case.
>
> When I try to access the table with a select wi
Original Message From: <[EMAIL PROTECTED]>
I have a table with many fields and the latest field is:
"CRC" character varying(255),
^^
Select * from base.points where crc = 'e19e26330a0db2f2435106b16623fa82'
What happens when you enter:
Select * from base.points where "CRC" = 'e19e26
Hi list,
I have a table with many fields and the latest field is:
"CRC" character varying(255),
When I try to access the table with a select with a where clause like
Select * from base.points where crc = 'e19e26330a0db2f2435106b16623fa82'
The error on the Subject of this e-mail allways appear
>What does this do that inheritance doesn't already do? I don't think I see
>anything.
- So, we have proved, that all, what you offer to make on your a-a-a...
Fortran, is possible to make on assembler.
- First, I know this without you, second, speech was not about that.
Newness is not "what",
13 matches
Mail list logo
