http://transportequispe.sc36.info/gifts.php?mid=52s=63aqusa=397ob=67
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
Am 05.12.2011 17:02, schrieb Cédric Villemain:
Le 5 décembre 2011 12:16, Frank Lanitz fr...@frank.uvena.de a écrit :
Hi list,
We had in past from time to time the issue, that the standby server is
stopping recovering, creating a new timeline and become up and running.
In parallel to check
Dear all,
I have a table with more than 10 million rows in a postgresql database.
In the table two columns are of type numeric(12,8) and contains lat lon
of the locations. But in more than thousand rows values are empty.
Below is the snapshot of two rows :-
select * from table where lat=NULL;
Above query also returns 0 rows.
Thanks
Bèrto ëd Sèra wrote:
Hi,
haven't checked this personally, but first of all... what if they are
simply stored as NULLs?
Bèrto
On 6 December 2011 13:39, Adarsh Sharma adarsh.sha...@orkash.com
try
select * from table where lat IS NULL;
Bèrto
:-) It works, Thanks a lot Berto !
can you explain how it works or any link that explain the difference
between 2 queries.
Best regards
Adarsh
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your
On 06/12/2011 11:00, Adarsh Sharma wrote:
try
select * from table where lat IS NULL;
Bèrto
:-) It works, Thanks a lot Berto !
can you explain how it works or any link that explain the difference
between 2 queries.
As I understand it, your first query returned nothing because NULL is
On 6 December 2011 12:00, Adarsh Sharma adarsh.sha...@orkash.com wrote:
select * from table where lat IS NULL;
can you explain how it works or any link that explain the difference between
2 queries.
That's because of the 3-valued logic of SQL.
x=NULL always evaluates to NULL, because it is
Hi,
As I understand it, your first query returned nothing because NULL is
simply unknown - and since you can never know what it's equal to,
looking for equality with NULL will never find anything.
Yes, you can basically think of NULLs in SQL as having the same role of
zeros in division.
Continuing this talk on general, as requested by Craig.
I have a functional Index on a table that is relative expensive to calculate.
Now I noticed on every update of even index-unrelated fields of the table the
index function is calculated again and again.
I currenly understand that if the
btw, HOT was introduced in 8.3.
On 6 December 2011 14:51, Daniel Migowski dmigow...@ikoffice.de wrote:
Continuing this talk on general, as requested by Craig.
I have a functional Index on a table that is relative expensive to calculate.
Now I noticed on every update of even index-unrelated
On Sun, Dec 4, 2011 at 7:41 PM, Phoenix Kiula phoenix.ki...@gmail.com wrote:
On Sun, Dec 4, 2011 at 7:14 PM, Alban Hertroys haram...@gmail.com wrote:
On 4 Dec 2011, at 11:19, Phoenix Kiula wrote:
INSERTs in the parent table don't need to check for any reference from the
child table,
You may have seen this, but RedGate software is sponsoring a contest
to send a DBA on a suborbital space flight.
And there is a PostgreSQL representativeme!
https://www.dbainspace.com/finalists/joe-miller
Voting is open for 7 days. Don't let one of those Oracle or SQL Server
punks win :p
-Original Message-
From: pgsql-general-ow...@postgresql.org
[mailto:pgsql-general-ow...@postgresql.org] On Behalf Of Phoenix Kiula
Sent: Tuesday, December 06, 2011 11:46 AM
To: Alban Hertroys
Cc: PG-General Mailing List
Subject: Re: [GENERAL] Foreign keys question (performance)
On Sun,
On Tue, Dec 6, 2011 at 10:56 AM, Joe Miller joe.d.mil...@gmail.com wrote:
You may have seen this, but RedGate software is sponsoring a contest
to send a DBA on a suborbital space flight.
And there is a PostgreSQL representativeme!
https://www.dbainspace.com/finalists/joe-miller
Voting
2011/12/6 Merlin Moncure mmonc...@gmail.com:
On Tue, Dec 6, 2011 at 10:56 AM, Joe Miller joe.d.mil...@gmail.com wrote:
You may have seen this, but RedGate software is sponsoring a contest
to send a DBA on a suborbital space flight.
And there is a PostgreSQL representativeme!
+1 say hello to Laika, if she's still there :)
Bèrto
On 6 December 2011 20:33, Torello Querci tque...@gmail.com wrote:
2011/12/6 Merlin Moncure mmonc...@gmail.com:
On Tue, Dec 6, 2011 at 10:56 AM, Joe Miller joe.d.mil...@gmail.com
wrote:
You may have seen this, but RedGate software is
On 12/06/2011 08:45 AM, Phoenix Kiula wrote:
On Sun, Dec 4, 2011 at 7:41 PM, Phoenix Kiulaphoenix.ki...@gmail.com wrote:
On Sun, Dec 4, 2011 at 7:14 PM, Alban Hertroysharam...@gmail.com wrote:
On 4 Dec 2011, at 11:19, Phoenix Kiula wrote:
I have a problem.
Here's my table designs. The
__
From: Merlin Moncure mmonc...@gmail.com
To: Joe Miller joe.d.mil...@gmail.com
Cc: pgsql-general@postgresql.org
Sent: Tuesday, 6 December 2011, 17:30
Subject: Re: [GENERAL] PostgreSQL DBA in SPCE
On Tue, Dec 6, 2011 at 10:56 AM, Joe Miller
On 12/06/2011 01:56 PM, Glyn Astill wrote:
__
From: Merlin Moncure mmonc...@gmail.com
To: Joe Miller joe.d.mil...@gmail.com
Cc: pgsql-general@postgresql.org
Sent: Tuesday, 6 December 2011, 17:30
Subject: Re: [GENERAL] PostgreSQL DBA in SPCE
On Tue,
On Tue, Dec 6, 2011 at 2:20 PM, Rob Sargent robjsarg...@gmail.com wrote:
On 12/06/2011 01:56 PM, Glyn Astill wrote:
__
From: Merlin Moncure mmonc...@gmail.com
To: Joe Miller joe.d.mil...@gmail.com
Cc: pgsql-general@postgresql.org
Sent: Tuesday, 6 December
I've had a couple people mention that they hadn't received it, but
most people seem to be getting it no problem. I'll mention it to
RedGate.
Thanks!
On Tue, Dec 6, 2011 at 4:27 PM, Scott Marlowe scott.marl...@gmail.com wrote:
On Tue, Dec 6, 2011 at 2:20 PM, Rob Sargent robjsarg...@gmail.com
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 12/6/2011 3:27 PM, Scott Marlowe wrote:
On Tue, Dec 6, 2011 at 2:20 PM, Rob Sargent robjsarg...@gmail.com
wrote:
On 12/06/2011 01:56 PM, Glyn Astill wrote:
__
From: Merlin Moncure mmonc...@gmail.com To: Joe
On 12/06/2011 02:31 PM, Joe Miller wrote:
I've had a couple people mention that they hadn't received it, but
most people seem to be getting it no problem. I'll mention it to
RedGate.
Thanks!
On Tue, Dec 6, 2011 at 4:27 PM, Scott Marlowe scott.marl...@gmail.com wrote:
On Tue, Dec 6, 2011
voted. good luck!
On Tue, Dec 6, 2011 at 12:13 AM, Rafael Ostertag r...@opencsw.org wrote:
Hi list
I'm in the course of creating PostgreSQL packages for Solaris. One of the
requirement is to install different PostgreSQL versions in parallel, the
other
is to have all the libraries stuffed in one place.
Now,
Hi All
Please help me .
Thanks...
Tamanna
On Mon, Dec 5, 2011 at 12:45 PM, tamanna madaan
tamanna.mad...@globallogic.com wrote:
Hi Tomas
I tried it on the system having postgres-8.4.0 . And the behavior is same
.
Cluster means a group of machines having postgres installed on all of
On 12/06/11 8:30 PM, raghu ram wrote:
I'm in the course of creating PostgreSQL packages for Solaris. One
of the
requirement is to install different PostgreSQL versions in
parallel, the other
is to have all the libraries stuffed in one place.
Now, if I install, let's
On 06/12/11 22:51, Daniel Migowski wrote:
Continuing this talk on general, as requested by Craig.
I have a functional Index on a table that is relative expensive to calculate.
Now I noticed on every update of even index-unrelated fields of the table the
index function is calculated again
Hi John
On Tue, Dec 06, 2011 at 08:35:58PM -0800, John R Pierce wrote:
On 12/06/11 8:30 PM, raghu ram wrote:
I'm in the course of creating PostgreSQL packages for Solaris. One
of the
requirement is to install different PostgreSQL versions in
parallel, the other
is to
On 12/06/11 10:37 PM, Rafael Ostertag wrote:
its apparent to me from the /opt/csw prefix he mentions that he's
building PostgreSQL for the Blastwave/OpenCSW Solaris software
repositories, and HAS to put the libs in /opt/csw/lib due to project
policies.
Exactly. Thanks for
Hi Alban/Craig,
Employeedetailinsert is procedure I have created in PostgreSQL. When I try to
execute the procedure directly in Pgadmin as
EXEC Employeedetailinsert (parameters same as below) It works fine with desired
result.
But When I call the procedure in Classic ASP I get the below
Hi there,
I am in the process of porting an application from V8.1 to 9.x
Now I have the following situation:
there is a function tsearch2:
CREATE FUNCTION tsearch2() RETURNS trigger
AS '$libdir/tsearch2', 'tsearch2'
LANGUAGE c;
a second function:
CREATE FUNCTION dropatsymbols(text)
32 matches
Mail list logo