Hi all,
I know we have LIMIT to limit the number of rows returned, I wonder if there is
a way to indicate an offset.
e.g.
Select * from Test offset 10, limit 4;
retrieve all Test, return 4 rows from the 10th row
thanks,
kathy
---(end of broadcast)--
I saw this method of Statement class in jdbc.
Will the return int contain the autogenerated key value ??
public int executeUpdate(String sql,
int autoGeneratedKeys)
throws SQLException
thanks,
kathy
Scott Chapman wrote:
> On Monday 10 November 2003 08
Do you mean that, this doesn't work any more ??
from jdbc
connextion.setAutoCommit(false)
Tom Lane wrote:
> Thierry Missimilly <[EMAIL PROTECTED]> writes:
> > I have got an error with PostgreSQL-7.4Beta4 :
> > ERROR SET AUTOCOMMIT TO OFF is no longer supported
> > I used these option to load hu
Hi,
I got this message. Is that because the string id too long ??
Where is the String length defined ??
thanks,
Kathy
insert into test (testid)
values('FAKEJOBMGRNAMEJOBNAME-020031016211324.144-06002elID--0jobname-0Thu Oct16
21:13:24 MDT 2003');
ERROR: pg_atoi: error in
"FAKEJOBMGRNAMEJOBNAM
never mind, it was the wrong type.
sorry,
> X-Original-To: [EMAIL PROTECTED]
> Date: Thu, 16 Oct 2003 21:21:41 -0600 (MDT)
> From: Kathy Zhu <[EMAIL PROTECTED]>
> Subject: [GENERAL] pg_atoi
> To: [EMAIL PROTECTED]
> X-Virus-Scanned: by amavisd-new at postgresql.org
>
:53:02 -0700
> From: Dennis Gearon <[EMAIL PROTECTED]>
> User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.4)
Gecko/20030624
> X-Accept-Language: en-us, ru, es-mx
> To: Kathy Zhu <[EMAIL PROTECTED]>
> CC: [EMAIL PROTECTED]
> Subject: Re: [GENERAL] gro
Hi,
I notices a weird thing here.
version 7.2.1
on Solaris
table "test", has a field "state".
There are 4 "state" values, 1, 2, 3, 4.
select count(*) from test group by state;
took 11500 msec
but
select count(*) from test where state = 1;
select count(*) from test where state = 2;
select coun
(CEST)
> From: Peter Eisentraut <[EMAIL PROTECTED]>
> X-X-Sender: [EMAIL PROTECTED]
> To: Kathy Zhu <[EMAIL PROTECTED]>
> Cc: [EMAIL PROTECTED]
> Subject: Re: [GENERAL] encoding again
> X-Virus-Scanned: by amavisd-new at postgresql.org
> X-Mailing-List: pgsql-gener
Hi, sorry that this email is a little bit long, but it is actully not :-))
I have a database 'unidb' created with -E UNICODE.
$ psql -l
List of databases
Name| Owner | Encoding
---+-+---
unidb | kathy | UNICODE
I input Chinese data in
Do you mean that soring doesn't work for en_US locale ???
And, does encoding affect sorting at all ??
thanks,
kathy
Tom Lane wrote:
"Tim Edwards" <[EMAIL PROTECTED]> writes:
When I sort ASC on the varchar I get some strange results. Here a section of
data cut after running a sort. It starts with
Hi all,
What are the relationship/dependencies between encoding and locale settings ??
thanks,
kathy
---(end of broadcast)---
TIP 8: explain analyze is your friend
Ok, thanks for all the discussion followed, vey educational :-))
But nobody really followed up my question :-(
For example, you have a table that is displayed in the browser. You want to let
the user do sorting on one or multible columns, including those which contain
localized strings.
If the d
How can you have two tables with the same name in one database ??
How do you differentiate them when you use it in queries ??
> X-Original-To: [EMAIL PROTECTED]
> Date: Sun, 20 Jul 2003 21:23:12 +0100 (BST)
> From: "Nigel J. Andrews" <[EMAIL PROTECTED]>
> X-Sender: [EMAIL PROTECTED]
> To: [EMAIL
a way to update the expected/*out files ??
thanks,
kathy
> X-Original-To: [EMAIL PROTECTED]
> Date: Mon, 14 Jul 2003 16:10:15 -0600 (MDT)
> From: Kathy Zhu <[EMAIL PROTECTED]>
> Subject: [GENERAL] change NAMEDATALEN to 64
> To: [EMAIL PROTECTED]
> X-Virus-Scanned: by
14 matches
Mail list logo
