[SQL] "too big" transactions

2000-10-19 Thread Edmar Wiggers
How does PostgreSQL handles a "too big" transaction? By that I mean a transaction which, after a certain point, there will be no way to roll back. On PgSQL, maybe that only happens when the disk fills. Is there a configurable "size" limit for a single transaction? In addition, what happens if th

[SQL] Re: [HACKERS] Conditional query plans.

2000-10-19 Thread Tom Lane
"Michael Richards" <[EMAIL PROTECTED]> writes: > The second and probably less optimal plan would be to create a hash > of these 25 answers and do a sequential scan on users updating rows > where id is found in that hash. Given the presence of the "materialize" nodes, I don't think this query pl

[SQL] what is the best way to set-up keywords in tables and Queries ?

2000-10-19 Thread lesstif
what is the best way to set-up keywords in tables and Queries? please post examples! I am worried about a field for each keyword less

Re: [SQL] COUNT

2000-10-19 Thread bmccoy
On Fri, 20 Oct 2000, Craig May wrote: > How do I get a row count, like "Select [COUNT] from Table" ?? SELECT COUNT(*) FROM Brett W. McCoy http://www.chapelperilous.net --- Man

Re: [SQL] COUNT

2000-10-19 Thread Daniel Wickstrom
> "Brian" == Brian C Doyle <[EMAIL PROTECTED]> writes: Brian> Hello, You will need to do "SELECT count(attribute) FROM Brian> table;" or SELECT count(table.attribute);" You need to watch this: acspg=# create table tst ( acspg(# a integer acspg(# ); CREATE acspg=# insert into tst v

Re: [SQL] COUNT

2000-10-19 Thread Jie Liang
Hi, there, You want how many rows in your table??? select count(*) from yourtablename; Craig May wrote: > Hi, > > How do I get a row count, like "Select [COUNT] from Table" ?? > > Regards, > Craig May > > Enth Dimension > http://www.enthdimension.com.au -- Jie LIANG Internet Products Inc. 1

Re: [SQL] COUNT

2000-10-19 Thread Brian C. Doyle
Hello, You will need to do "SELECT count(attribute) FROM table;" or SELECT count(table.attribute);" At 04:58 AM 10/20/00 +, Craig May wrote: >Hi, > >How do I get a row count, like "Select [COUNT] from Table" ?? > >Regards, >Craig May > >Enth Dimension >http://www.enthdimension.com.au

Re: [SQL] COUNT

2000-10-19 Thread Frank Bax
Select count(*) from Table At 04:58 AM 10/20/00 +, Craig May wrote: >Hi, > >How do I get a row count, like "Select [COUNT] from Table" ?? > >Regards, >Craig May > >Enth Dimension >http://www.enthdimension.com.au > >

[SQL] COUNT

2000-10-19 Thread Craig May
Hi, How do I get a row count, like "Select [COUNT] from Table" ?? Regards, Craig May Enth Dimension http://www.enthdimension.com.au

Re: [SQL] substr

2000-10-19 Thread Jeff MacDonald
> Jeff MacDonald <[EMAIL PROTECTED]> writes: > > i noticed that substr behaves a bit different in pgsql than perl > > ie select foo from table where substr(foo,1,1) = 'X'; > > > just wondering on the reasoning for this offset ? > > Larry Wall and the SQL92 authors didn't talk to each other...

Re: [SQL] substr

2000-10-19 Thread Tom Lane
Jeff MacDonald <[EMAIL PROTECTED]> writes: > i noticed that substr behaves a bit different in pgsql than perl > ie select foo from table where substr(foo,1,1) = 'X'; > just wondering on the reasoning for this offset ? Larry Wall and the SQL92 authors didn't talk to each other... We are implemen

[SQL] substr

2000-10-19 Thread Jeff MacDonald
i noticed that substr behaves a bit different in pgsql than perl ie select foo from table where substr(foo,1,1) = 'X'; initially i thought it should be substr(foo,0,1) just wondering on the reasoning for this offset ? Jeff MacDonald, - Post