Sorry for buggering you, I get the point :)
And thanks for the order by limit 1 hint. That will do.
Ulrich Meis
---(end of broadcast)---
TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faqs/FAQ.html
> Sorry for buggering you, I get the point :)
I think you mean 'bugging.' Buggering is something quite different.
---(end of broadcast)---
TIP 8: explain analyze is your friend
Hi all.
My comment sentence of Primary-Key is lost.!
See this sample below.
---
CREATE TABLE "MyTransaction"
(
"XID" int4 NOT NULL,
"LastSeqId" int4 NOT NULL,
"HostId" int4 NOT NULL,
CONSTRAINT "MyTransaction_pkey" PRIMARY KEY ("
Rod,
If the table has 100,000 tupples your query is generating 100,000 new
tupples...
Try:
select * from quotes where id = (
select int8( 1 + random() * (
select id from quotes order by id desc limit 1)));
JLL
Rod Taylor wrote:
>
> > select * from quotes where id=1+round(random()* cast (
POSTGRESQL BUG REPORT TEMPLATE
Your name : Ulrich Meis
Your email address : u.meis ( at ) gmx ( dot ) de
Sys
Howdy Folks,
I was dumping a database to test backups of the tsearch2 objects, and as I glanced
through the output of pg_dump -Ft database > DBdata.bak, I found a table that I hadn't
seen before in the table. It's a table that's used in other databases, but not this
one. Somehow it had gotten
On Thu, 18 Sep 2003, Josh Eno wrote:
> The reason I'd never noticed the table is because in doing a \d it
> doesn't show up in the table list. If I try to do a \d TABLE_NAME, I
> can use to autocomplete the name, but then it says the table
> doesn't exist. I can't select any of those 40,000 ro
POSTGRESQL BUG REPORT TEMPLATE
Your name : Edmund Bacon
Your email address : [EMAIL PRO
"Hiroshi Saito" <[EMAIL PROTECTED]> writes:
> My comment sentence of Primary-Key is lost.!
Yeah, pg_dump missed comments attached to primary key constraints.
Fixed for 7.4.
regards, tom lane
---(end of broadcast)---
TIP 7: d
