Hi Tom lane
How can I get in deep about locale and encoding?
Please advise url or resource!
thanks for your kindness
tina
- Original Message -
From: "Tom Lane" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Cc:
Sent: Sunday, February 13, 2005 1:48 PM
Subject: Re: [GENERAL] problem with
elein wrote:
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
WHE
At 09:57 AM 2/13/2005 +, Russ Brown wrote:
I've thought about things like this in the past, and a thought that
occurred to me was to add a functional index on just_digits(telephone) to
the table. Would this not allow the above query to use an index while
searching?
I think it should. But fo
Lincoln Yeoh wrote:
At 09:57 AM 2/13/2005 +, Russ Brown wrote:
I've thought about things like this in the past, and a thought that
occurred to me was to add a functional index on just_digits(telephone)
to the table. Would this not allow the above query to use an index
while searching?
I t
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 point is that those notes aren'
how to compare dates with timestamp..if i dont care about
the hour:minute part of the timestamp... i.e. i want
to be able to do exact match :
timestamp in (select date from table where .)
tia
---(end of broadcast)---
TIP 5: Have you checked
On Sun, 13 Feb 2005 18:57:30 +0200, raptor <[EMAIL PROTECTED]> wrote:
> how to compare dates with timestamp..if i dont care about
> the hour:minute part of the timestamp... i.e. i want
> to be able to do exact match :
>
> timestamp in (select date from table where .)
timestamp::DATE in ((sele
> -Original Message-
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED] On Behalf Of Bruce Momjian
> Sent: 13 February 2005 15:16
> To: Tom Lane
> Cc: Russell Smith; pgsql-general@postgresql.org;
> [EMAIL PROTECTED]
> Subject: Re: [pgsql-www] [GENERAL] Website Documentation
>
> Uh,
Dave Page wrote:
> > Uh, my next question is why isn't the documentation updated on the web
> > site for each minor release? We update the tarball HTML for each
> > release. This seems like a pretty large omission.
> >
> > Is it the web comments that prevent it?
>
> No, it's my free time, and i
> -Original Message-
> From: Bruce Momjian [mailto:[EMAIL PROTECTED]
> Sent: 13 February 2005 18:12
> To: Dave Page
> Cc: Tom Lane; Russell Smith; pgsql-general@postgresql.org;
> [EMAIL PROTECTED]
> Subject: Re: [pgsql-www] [GENERAL] Website Documentation
>
> Agreed. Who controls the
On Sun, 2005-02-13 at 18:57 +0200, raptor wrote:
> how to compare dates with timestamp..if i dont care about
> the hour:minute part of the timestamp... i.e. i want
> to be able to do exact match :
>
> timestamp in (select date from table where .)
Try something like this: (created is a timest
Dave Page wrote:
>
>
> > -Original Message-
> > From: Bruce Momjian [mailto:[EMAIL PROTECTED]
> > Sent: 13 February 2005 18:12
> > To: Dave Page
> > Cc: Tom Lane; Russell Smith; pgsql-general@postgresql.org;
> > [EMAIL PROTECTED]
> > Subject: Re: [pgsql-www] [GENERAL] Website Documenta
__
Switch to Netscape Internet Service.
As low as $9.95 a month -- Sign up today at http://isp.netscape.com/register
Netscape. Just the Net You Need.
New! Netscape Toolbar for Internet Explorer
Search from anywhere on the Web and b
Dave Page wrote:
-Original Message-
From: Bruce Momjian [mailto:[EMAIL PROTECTED]
Sent: 13 February 2005 18:12
To: Dave Page
Cc: Tom Lane; Russell Smith; pgsql-general@postgresql.org;
[EMAIL PROTECTED]
Subject: Re: [pgsql-www] [GENERAL] Website Documentation
Agreed. Who controls the
On Sun, 2005-02-13 at 01:24 -0500, Greg Stark wrote:
> 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
Hi,
Im really noob when it comes to R-Tree indexes, but we have a use for one.
What I've done is setup time along the X axis and some other quantity (such
as a the minimum and maximum of some other, pertinent value, which we want
to search quickly) along the Y axis. These quite convieniently make
I am using PostgreSQL 7.4.7
I have a table with serveral fields two of these are a serialno
(bigserial) and name(varchar). I have created two indexs on these
fields.
1) on name
2) on name,serialno
if I use the command
'select * from table order by name limit 1'
everything is OK
if I use th
On Mon, 14 Feb 2005, Neil Dugan wrote:
> I am using PostgreSQL 7.4.7
> I have a table with serveral fields two of these are a serialno
> (bigserial) and name(varchar). I have created two indexs on these
> fields.
> 1) on name
> 2) on name,serialno
> if I use the command
> 'select * from t
On Sun, 2005-02-13 at 20:40 -0800, Stephan Szabo wrote:
> On Mon, 14 Feb 2005, Neil Dugan wrote:
>
> > I am using PostgreSQL 7.4.7
> > I have a table with serveral fields two of these are a serialno
> > (bigserial) and name(varchar). I have created two indexs on these
> > fields.
> > 1) on na
19 matches
Mail list logo
