>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
"F.Bissett" <[EMAIL PROTECTED]> writes:
> On Fri=
> , 11 Feb 2005 19:56:33 -0800, Jeff Davis wrote: font-size:10pt;color:navy;">>=A0Try using the "~" regex matching operato=
> r instead of ILIKE. N style=3D"font-size:10pt;color:navy;">> 10pt;">>=A0Regar=
> ds, size:10pt;color:navy;">>=A0Jeff Davis
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 n
> 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 woul
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 ad
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
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 bel
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 ch
Bruce Momjian 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 website. We
should
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 m
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) & s
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.
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 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 p
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
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 ind
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
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 mo
<[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 d
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 T
25 matches
Mail list logo
