use --disable-triggers
Hey! Cool. Worked. Thanks!
---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
On Fri, 11 Feb 2005 19:56:33 -0800, Jeff Davis wrote: Try using the "~" regex matching operator instead of ILIKE. Regards, Jeff Davis
I still need the ILIKE to compare the returned value with $telephone.
I have the following PHP to check an input string for non numeric characters:
$tel =
On Sat, 2005-02-12 at 10:31, F.Bissett wrote:
On Fri, 11 Feb 2005 19:56:33 -0800, Jeff Davis wrote:
Try using the ~ regex matching operator instead of ILIKE.
Regards,
Jeff Davis
I still need the ILIKE to compare the returned value with $telephone.
I have the following PHP
F.Bissett [EMAIL PROTECTED] writes:
/headBODY BGCOLOR=3D#F0F0F0 pSPAN style=3Dfont-size:10pt;On Fri=
, 11 Feb 2005 19:56:33 -0800, Jeff Davis wrote:br //SPANSPAN style=3D=
font-size:10pt;color:navy;gt;=A0Try using the ~ regex matching operato=
r instead of ILIKE./SPANSPAN
Tony Caduto wrote:
Hi,
Does anyone know if there is a way to get the backends IP address from
the PID?
I am using the view pg_stat_activity and it would be nice if it would
also display the IP address along with the PID.
I can see the IP address when I do a ps -ef but it would be nice to
Tony Caduto wrote:
Hi,
Does anyone know if there is a way to get the backends IP address from
the PID?
I am using the view pg_stat_activity and it would be nice if it would
also display the IP address along with the PID.
I can see the IP address when I do a ps -ef but it would be nice to
Berend Tober wrote:
Tony Caduto wrote:
Hi,
Does anyone know if there is a way to get the backends IP address from
the PID?
I am using the view pg_stat_activity and it would be nice if it would
also display the IP address along with the PID.
I can see the IP address when I do a ps
Dear all,
There does not seems to be the latest version of the PostgreSQL documentation
online.
The release notes for 8.0 and 7.4 only go to version 8.0.0 and 7.4.6.
Where can I find the changes made from 7.4.6 - 7.4.7, and 8.0.0 - 8.0.1?
Should the site be updates?
Thanks
Russell Smith
Russell Smith wrote:
Dear all,
There does not seems to be the latest version of the PostgreSQL documentation
online.
The release notes for 8.0 and 7.4 only go to version 8.0.0 and 7.4.6.
Where can I find the changes made from 7.4.6 - 7.4.7, and 8.0.0 - 8.0.1?
If you want the changes
Russell Smith wrote:
Dear all,
There does not seems to be the latest version of the PostgreSQL documentation
online.
The release notes for 8.0 and 7.4 only go to version 8.0.0 and 7.4.6.
Where can I find the changes made from 7.4.6 - 7.4.7, and 8.0.0 - 8.0.1?
Should the site be updates?
I
On Sun, 13 Feb 2005 01:22 pm, Bruce Momjian wrote:
Russell Smith wrote:
Dear all,
There does not seems to be the latest version of the PostgreSQL
documentation online.
The release notes for 8.0 and 7.4 only go to version 8.0.0 and 7.4.6.
Where can I find the changes made from
Bruce Momjian pgman@candle.pha.pa.us writes:
Russell Smith wrote:
The release notes for 8.0 and 7.4 only go to version 8.0.0 and 7.4.6.
If you want the changes to the server between releases see the Release
notes in the documentation.
I think his point is that those notes aren't up on the
Hi,
I am trying to find out how to get the next record according to a
particular index.
I have a table with a name field and a serial field. The name field
isn't unique so I made an index on name(varchar) serialno(bigserial).
I also have an index just on 'name'. I am having trouble working out
On Sun, Feb 13, 2005 at 13:06:52 +1100,
Russell Smith [EMAIL PROTECTED] wrote:
Dear all,
There does not seems to be the latest version of the PostgreSQL documentation
online.
The release notes for 8.0 and 7.4 only go to version 8.0.0 and 7.4.6.
Where can I find the changes made from
On Sun, Feb 13, 2005 at 14:03:02 +1100,
Neil Dugan [EMAIL PROTECTED] wrote:
Hi,
I am trying to find out how to get the next record according to a
particular index.
I have a table with a name field and a serial field. The name field
isn't unique so I made an index on name(varchar)
On Sat, 2005-02-12 at 21:47 -0600, Bruno Wolff III wrote:
On Sun, Feb 13, 2005 at 14:03:02 +1100,
Neil Dugan [EMAIL PROTECTED] wrote:
Hi,
I am trying to find out how to get the next record according to a
particular index.
I have a table with a name field and a serial field. The name
No doubt someone more adept at perl can write
this function as a one-liner.
create or replace function just_digits(text)
returns text as
$$
my $innum = $_[0];
$innum =~ s/\D//g;
return $innum;
$$ language 'plperl'
SELECT telephone FROM addresses
WHERE user_id
On Sun, 13 Feb 2005 01:45 pm, Tom Lane wrote:
Bruce Momjian pgman@candle.pha.pa.us writes:
Russell Smith wrote:
The release notes for 8.0 and 7.4 only go to version 8.0.0 and 7.4.6.
If you want the changes to the server between releases see the Release
notes in the documentation.
I
Tom Lane [EMAIL PROTECTED] writes:
In the cases I'm concerned about, DROP VIEW would fail unless you used
CASCADE, and the subsequent CREATE VIEW would not magically bring back
the dependent objects the CASCADE had killed. The entire *point* of
REPLACE VIEW is that it does not have the side
Hi all
I use postgresql7.2 / redhat8
I try "select 'X1'='X2' ;" and X1=(D button) in
thai language, X2=(8 button) in thai language
result is true .This is wrong
result!.
How to solve this problem! please
advise!
tina
Neil Dugan [EMAIL PROTECTED] writes:
Hi,
I am trying to find out how to get the next record according to a
particular index.
I have a table with a name field and a serial field. The name field
isn't unique so I made an index on name(varchar) serialno(bigserial).
I also have an index just
Greg Stark [EMAIL PROTECTED] writes:
It seems like this would be a huge behaviour change though. I don't suppose
the spec says anything about how views are supposed to respond to changes in
base context does it?
SQL99 doesn't have RENAME COLUMN nor ALTER COLUMN TYPE, so the exact
cases don't
Tom Lane [EMAIL PROTECTED] writes:
I see nothing at all in the spec that justifies the idea of keep around
the source text and reinterpret it. They don't think that way; they
think in terms of thoroughly-processed descriptors stored in the
system catalogs.
Huh. The thing I find most
[EMAIL PROTECTED] writes:
I use postgresql7.2 / redhat8
I try select 'X1'='X2' ; and X1=(D button) in thai language, =
X2=(8 button) in thai language
result is true .This is wrong result!.
We've seen a lot of reports of bizarre behavior when you select a
database encoding that does not
Greg Stark [EMAIL PROTECTED] writes:
Huh. The thing I find most jarring about this way of thinking is that it means
I can have objects in my database that don't correspond to any source code I
have saved.
[ shrug... ] Almost any form of ALTER command gives rise to that
situation; RENAME TABLE
25 matches
Mail list logo