Hello, colleagues !
I have to develop some functions onto postgresql server 9.2 based on Gnu
Scientific Library. Under redhat I compile gsl with ./configure
--prefix=/usr/local compile postgresql with ./configure --prefix=/usr/local
--with-uuid-ossp --with-xml --with-xslt. After that I try to put
Hi
Firstly let me mention I am a noob to postgres,DB and sql anyway, I have a
column with First names and need to list names that have non-alphanumeric
characters in them like + or * and the list goes on. I did google a bit and
tried:
select * from TABLE where first_name not like
On 4/11/2013 11:23 PM, Baboo, Isa wrote:
Firstly let me mention I am a noob to postgres,DB and sql anyway, I
have a column with First names and need to list names that have
non-alphanumeric characters in them like + or * and the list goes on.
I did google a bit and tried:
/select * from
Hi
Thanks for the response but I tried that and it does not work here is an
example of names which still display.
test
sadadds
Hillary
BEN NAME
ALAN MCGARVEY +
From: pgsql-general-ow...@postgresql.org
[mailto:pgsql-general-ow...@postgresql.org] On Behalf Of John R Pierce
Sent: 12 April 2013
From: pgsql-general-ow...@postgresql.org
[mailto:pgsql-general-ow...@postgresql.org] On Behalf Of John R Pierce
Sent: 12 April 2013 08:41 AM
To: pgsql-general@postgresql.org
Subject: Re: [GENERAL] list non alphanumeric
On 4/11/2013 11:23 PM, Baboo, Isa wrote:
Firstly let me mention I am
On 4/11/2013 11:50 PM, Baboo, Isa wrote:
Thanks for the response but I tried that and it does not work here is
an example of names which still display.
test
sadadds
Hillary
BEN NAME
ALAN MCGARVEY +
well, at least one of those has a space inline, you didn't say that was
acceptable,
Hi
It still displaying everything, maybe it is the spaces?
test
sadadds
Hillary
BEN NAME
BOB
/+
...skipping
ALAN MCGARVEY +
-Original Message-
From: Ian Lawrence Barwick [mailto:barw...@gmail.com]
Sent: 12 April 2013 09:08 AM
To: Baboo, Isa
Cc: John R Pierce;
Hi
Sorry guys I should have mention spaces, I did but it was a bit late. Anyway
that [A-Za-z0-9 ] worked thanks John.
From: pgsql-general-ow...@postgresql.org
[mailto:pgsql-general-ow...@postgresql.org] On Behalf Of John R Pierce
Sent: 12 April 2013 09:12 AM
To: pgsql-general@postgresql.org
On 2013-04-10 22:35, Thomas Kellerer wrote:
John R Pierce wrote on 10.04.2013 21:28:
On 4/10/2013 6:15 AM, Thomas Kellerer wrote:
psql (one of the possible client applications) uses the datestyle
parameter to decide on how to format a date column when displaying
it.
If you change the
On 4/12/2013 12:42 AM, Condor wrote:
and ISO, DMY show me: 2012-10-15 11:00:49.397908 if I use Postgres,
DMY show me
Mon 15 Oct 11:00:49.397908 2012
But I want to be formatted: 11:00:49 15-10-2012
use the date formatting functions, like...
select to_char(yourfield, 'HH:MI:SS
Any hints with this question I had posted to SO?
http://stackoverflow.com/questions/15965785/why-is-postgresql-9-1-not-using-index-for-simple-equality-select
Pasted here as well. Thanks.
My table `lead` has an index:
\d lead
...
Indexes:
lead_pkey PRIMARY KEY, btree (id)
On 4/12/2013 1:03 AM, Yang Zhang wrote:
db= explain select * from lead where email = 'blah';
QUERY PLAN
Seq Scan on lead (cost=0.00..319599.38 rows=1 width=5108)
Filter: (email =
Doesn't seem to be the case. This table has been around for a while
and should have been auto-analyzed by now. But anyway:
db= analyze lead;
ANALYZE
db= explain select * from lead where email = 'f...@blah.com';
QUERY PLAN
Hello,
I discovered that while upgrading PostgreSQL binaries through 'yum
update', with PGDG RPMs, the service is automatically restarted.
ISTM that this was not the case before 9.2.
May you confirm that this is a new behaviour appearing in 9.2?
Is it intended, and is there a way to prevent
On 12 April 2013 10:45, Yang Zhang yanghates...@gmail.com wrote:
explain select * from lead where email = 'f...@blah.com';
What about:
explain analyze select * from lead where email = 'f...@blah.com';
--
If you can't see the forest for the trees,
Cut the trees and you'll see there is no
On 2013-04-12 10:59, John R Pierce wrote:
On 4/12/2013 12:42 AM, Condor wrote:
and ISO, DMY show me: 2012-10-15 11:00:49.397908 if I use Postgres,
DMY show me
Mon 15 Oct 11:00:49.397908 2012
But I want to be formatted: 11:00:49 15-10-2012
use the date formatting functions, like...
2013/4/12 Condor con...@stz-bg.com
On 2013-04-12 10:59, John R Pierce wrote:
On 4/12/2013 12:42 AM, Condor wrote:
and ISO, DMY show me: 2012-10-15 11:00:49.397908 if I use Postgres, DMY
show me
Mon 15 Oct 11:00:49.397908 2012
But I want to be formatted: 11:00:49 15-10-2012
use the
On 4/12/2013 1:45 AM, Yang Zhang wrote:
db= explain select * from lead where email = 'f...@blah.com';
can you try
explain analyze select * from lead where email = 'f...@blah.com';
?
--
john r pierce 37N 122W
somewhere on the middle of the left coast
On 2013-04-10 19:06:12 -0400, Tom Lane wrote:
I wrote:
(Wanders away wondering just how much the regression tests exercise
holdable cursors.)
And the answer is they're not testing this code path at all, because if
you do
DECLARE c CURSOR WITH HOLD FOR ...
FETCH ALL FROM c;
On 04/12/2013 01:54 AM, Condor wrote:
--
john r pierce 37N 122W
somewhere on the middle of the left coast
Yes, I see this function but if I need to select 100 000 rows this mean
I think,
this function will be start 100 000 times. I mean when I ask the
stephane.schildkne...@postgres.fr writes:
I discovered that while upgrading PostgreSQL binaries through 'yum
update', with PGDG RPMs, the service is automatically restarted.
ISTM that this was not the case before 9.2.
I dunno whether Devrim's packages acted that way before 9.2, but
this is
Yang Zhang yanghates...@gmail.com writes:
db= explain select * from lead where email = 'blah';
QUERY PLAN
Seq Scan on lead (cost=0.00..319599.38 rows=1 width=5108)
Filter: (email =
It's actually just `text`.
I updated my SO question with some more info including explain analyze
(no difference), \d,
and your last incantation.
Thanks!
On Fri, Apr 12, 2013 at 7:11 AM, Tom Lane t...@sss.pgh.pa.us wrote:
Yang Zhang yanghates...@gmail.com writes:
db= explain select * from
Yang Zhang yanghates...@gmail.com writes:
I updated my SO question with some more info including explain analyze
(no difference), \d,
and your last incantation.
The question is being asked here, not in SO, and I find it rather
impolite of you to expect me to go chasing off to some other forum
Apologies for that Tom. I will paste the information in line once I'm
back at my computer. I do appreciate your help.
On Fri, Apr 12, 2013 at 10:24 AM, Tom Lane t...@sss.pgh.pa.us wrote:
Yang Zhang yanghates...@gmail.com writes:
I updated my SO question with some more info including explain
Hello.
This is simple example for describe my problem.
I created a table:
CREATE TABLE table0
(
id serial NOT NULL,
field0 integer,
field1 text
);
I created an unique index for this table:
CREATE UNIQUE INDEX idx_table0_unique
ON table0 ( field0, coalesce ( field1,
On 13/04/13 02:08, Tom Lane wrote:
stephane.schildkne...@postgres.fr writes:
I discovered that while upgrading PostgreSQL binaries through 'yum
update', with PGDG RPMs, the service is automatically restarted.
ISTM that this was not the case before 9.2.
I dunno whether Devrim's packages acted
Hello, colleagues !
I have to put some C-language functions onto postgresql server 9.2. These
functions are used GSL software library http://www.gnu.org/software/gsl/.
In Makefile for these functions I wrote LD_FLAGS = ... -lgsl, On some
source-based Linux distributions such as gentoo linux these
whiplash whipl...@bss.org.ua wrote:
sometimes I getting false unique violation
How do you know that they are false?
What version of PostgreSQL is this?
Can you create a small self-contained test case that demonstrates
the issue? (The snippets you provided probably excluded the cause
of the
On Fri, Apr 12, 2013 at 8:44 AM, whiplash whipl...@bss.org.ua wrote:
CREATE UNIQUE INDEX idx_table0_unique
ON table0 ( field0, coalesce ( field1, 'INDEX_COLUMN_NULL' ) );
I created function for insert only unique record (part of code):
BEGIN
INSERT INTO table0 ( field0, field1 )
30 matches
Mail list logo