pg.ddx.io pgsql-sql@postgresql.org mailing list archive
help / color / mirror / Atom feedInquiry From Form [pgsql]
13+ messages / 12 participants
[nested] [flat]
* Inquiry From Form [pgsql]
@ 2003-02-25 00:22 Jack Kiss <jackkiss@ecluboz.com>
0 siblings, 1 reply; 13+ messages in thread
From: Jack Kiss @ 2003-02-25 00:22 UTC (permalink / raw)
To: info@pgsql.com
Dear Sir/Madam,
I would like to find out two things:
1)Do you have a function which is similar to Oracle\'s DECODE.
2) Can you extract day of week (Monday,etc) from yours date functions.
Kind Regards,
Jack Kiss
^ permalink raw reply [nested|flat] 13+ messages in thread
* Re: Inquiry From Form [pgsql]
@ 2003-03-02 14:10 Greg Stark <gsstark@mit.edu>
parent: Jack Kiss <jackkiss@ecluboz.com>
0 siblings, 0 replies; 13+ messages in thread
From: Greg Stark @ 2003-03-02 14:10 UTC (permalink / raw)
To: Jack Kiss <jackkiss@ecluboz.com>; +Cc: pgsql-sql
Jack Kiss <jackkiss@ecluboz.com> writes:
> 1)Do you have a function which is similar to Oracle\'s DECODE.
Yes
> 2) Can you extract day of week (Monday,etc) from yours date functions.
Yes
Check out the "Date/Time Function and Operators" and the "Conditional
Expressions" sections of this:
http://www.ca.postgresql.org/users-lounge/docs/7.3/postgres/functions.html
--
greg
^ permalink raw reply [nested|flat] 13+ messages in thread
* Inquiry From Form [pgsql]
@ 2003-05-13 21:07 Issa <imohd@sdps.org>
0 siblings, 2 replies; 13+ messages in thread
From: Issa @ 2003-05-13 21:07 UTC (permalink / raw)
To: info@pgsql.com
Does postgreSQL support views?
Thanks,
Issa
^ permalink raw reply [nested|flat] 13+ messages in thread
* Inquiry From Form [pgsql]
@ 2003-05-15 02:04 eric <eric@vianet-express.com.br>
0 siblings, 1 reply; 13+ messages in thread
From: eric @ 2003-05-15 02:04 UTC (permalink / raw)
To: info@pgsql.com
in access i can put the content of a field \'date()\'. how could i do the same in postgres? when i set \'date()\', i\'ve got the error message \'zero-length defined identifier\'
tnx
^ permalink raw reply [nested|flat] 13+ messages in thread
* Re: Inquiry From Form [pgsql]
@ 2003-05-15 16:41 Ian Barwick <barwick@gmx.net>
parent: Issa <imohd@sdps.org>
1 sibling, 0 replies; 13+ messages in thread
From: Ian Barwick @ 2003-05-15 16:41 UTC (permalink / raw)
To: Issa <imohd@sdps.org>; info@pgsql.com; +Cc: pgsql-sql
On Tuesday 13 May 2003 23:07, Issa wrote:
> Does postgreSQL support views?
>
> Thanks,
> Issa
Yes, see:
http://www.postgresql.org/docs/view.php?version=7.3&idoc=1&file=sql-createview.html
Ian Barwick
barwick@gmx.net
^ permalink raw reply [nested|flat] 13+ messages in thread
* Re: Inquiry From Form [pgsql]
@ 2003-05-15 17:26 Stephan Szabo <sszabo@megazone23.bigpanda.com>
parent: Issa <imohd@sdps.org>
1 sibling, 0 replies; 13+ messages in thread
From: Stephan Szabo @ 2003-05-15 17:26 UTC (permalink / raw)
To: Issa <imohd@sdps.org>; +Cc: info@pgsql.com; Marc G. Fournier <scrappy@hub.org>; pgsql-sql
On Tue, 13 May 2003, Issa wrote:
> Does postgreSQL support views?
Yes, although making updatable views requires writing rules.
^ permalink raw reply [nested|flat] 13+ messages in thread
* Re: Inquiry From Form [pgsql]
@ 2003-05-15 17:27 Stephan Szabo <sszabo@megazone23.bigpanda.com>
parent: eric <eric@vianet-express.com.br>
0 siblings, 0 replies; 13+ messages in thread
From: Stephan Szabo @ 2003-05-15 17:27 UTC (permalink / raw)
To: eric <eric@vianet-express.com.br>; +Cc: info@pgsql.com; Marc G. Fournier <scrappy@hub.org>; pgsql-sql
On Wed, 14 May 2003, eric wrote:
> in access i can put the content of a field \'date()\'. how could i do
> the same in postgres? when i set \'date()\', i\'ve got the error
> message \'zero-length defined identifier\'
It would be helpful if you gave more information like the specific table
schema and insert/update that you are doing.
^ permalink raw reply [nested|flat] 13+ messages in thread
* Inquiry From Form [pgsql]
@ 2003-05-19 05:23 Rajendran <rajendran@davlin.co.in>
0 siblings, 0 replies; 13+ messages in thread
From: Rajendran @ 2003-05-19 05:23 UTC (permalink / raw)
To: info@pgsql.com
I need your help for getting particular records from the table in postgres.
How to use \'fetch\' keyword in postgres.
Can u please give me the syntax to retrieve the no of records in postgres?
^ permalink raw reply [nested|flat] 13+ messages in thread
* Re: Inquiry From Form [pgsql]
@ 2003-05-23 11:24 Christoph Haller <ch@rodos.fzk.de>
0 siblings, 1 reply; 13+ messages in thread
From: Christoph Haller @ 2003-05-23 11:24 UTC (permalink / raw)
To: pgsql-sql; +Cc: rajendran@davlin.co.in
>
> I am using Java language for getting first 10 records from the table
in postgres.
> I dont know how to fetch 10 records from the table.
> Raj
>
First answer is RTFM. But within psql you can fetch like this:
begin;
declare fu cursor for select * from foo;
fetch 10 in fu;
fetch 10 in fu;
...
close fu;
end;
Does this answer your question?
Regards, Christoph
^ permalink raw reply [nested|flat] 13+ messages in thread
* Re: Inquiry From Form [pgsql]
@ 2003-05-23 18:29 Achilleus Mantzios <achill@matrix.gatewaynet.com>
parent: Christoph Haller <ch@rodos.fzk.de>
0 siblings, 0 replies; 13+ messages in thread
From: Achilleus Mantzios @ 2003-05-23 18:29 UTC (permalink / raw)
To: Christoph Haller <ch@rodos.fzk.de>; +Cc: pgsql-sql@postgresql.org, <rajendran@davlin.co.in>
On Fri, 23 May 2003, Christoph Haller wrote:
> >
> > I am using Java language for getting first 10 records from the table
> in postgres.
> > I dont know how to fetch 10 records from the table.
> > Raj
> >
Could you try
selecy name from bar where serves_greek_tsipouro order by price limit 10;
> First answer is RTFM. But within psql you can fetch like this:
>
> begin;
> declare fu cursor for select * from foo;
> fetch 10 in fu;
> fetch 10 in fu;
> ...
> close fu;
> end;
>
> Does this answer your question?
>
> Regards, Christoph
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster
>
--
==================================================================
Achilleus Mantzios
S/W Engineer
IT dept
Dynacom Tankers Mngmt
Nikis 4, Glyfada
Athens 16610
Greece
tel: +30-210-8981112
fax: +30-210-8981877
email: achill@matrix.gatewaynet.com
mantzios@softlab.ece.ntua.gr
^ permalink raw reply [nested|flat] 13+ messages in thread
* Re: Inquiry From Form [pgsql]
@ 2003-07-03 11:19 Bruno Wolff III <bruno@wolff.to>
0 siblings, 1 reply; 13+ messages in thread
From: Bruno Wolff III @ 2003-07-03 11:19 UTC (permalink / raw)
To: Chris Schneider <cschneider@xede.com>; +Cc: info@pgsql.com; pgsql-sql
On Wed, Jul 02, 2003 at 16:26:09 -0300,
Chris Schneider <cschneider@xede.com> wrote:
> I know this is basic, but couldn\'t find and in a hurry to know the answer. When interfacing with PostgreSQL through PSQL, it appears that DML statements are auto-commited, that is, a change I make in one session is seen from another without the original session issueing a COMMIT. Is this a result of PSQL interface and if so, can it be turned off. Is PostgreSQL transactional in the sense that I can issue several DMLs and then ROLLBACK. If so, how. Thanks and sorry for the newbie question.
Autocommit is the default mode for psql. Use "begin;" to start a transaction.
And use "end;" to end a transaction. Note that unlike in sqlplus with Oracle,
any errors while in the transaction will abort it and you have to start
over.
All DML and most DDL statements are rollbackable by 7.3. I believe in 7.4
all DDL statements will be rollbackable.
^ permalink raw reply [nested|flat] 13+ messages in thread
* Re: Inquiry From Form [pgsql]
@ 2003-07-03 16:12 scott.marlowe <scott.marlowe@ihs.com>
parent: Bruno Wolff III <bruno@wolff.to>
0 siblings, 0 replies; 13+ messages in thread
From: scott.marlowe @ 2003-07-03 16:12 UTC (permalink / raw)
To: Bruno Wolff III <bruno@wolff.to>; +Cc: Chris Schneider <cschneider@xede.com>; info@pgsql.com; pgsql-sql
On Thu, 3 Jul 2003, Bruno Wolff III wrote:
> On Wed, Jul 02, 2003 at 16:26:09 -0300,
> Chris Schneider <cschneider@xede.com> wrote:
> > I know this is basic, but couldn\'t find and in a hurry to know the answer. When interfacing with PostgreSQL through PSQL, it appears that DML statements are auto-commited, that is, a change I make in one session is seen from another without the original session issueing a COMMIT. Is this a result of PSQL interface and if so, can it be turned off. Is PostgreSQL transactional in the sense that I can issue several DMLs and then ROLLBACK. If so, how. Thanks and sorry for the newbie question.
>
> Autocommit is the default mode for psql. Use "begin;" to start a transaction.
> And use "end;" to end a transaction. Note that unlike in sqlplus with Oracle,
> any errors while in the transaction will abort it and you have to start
> over.
>
> All DML and most DDL statements are rollbackable by 7.3. I believe in 7.4
> all DDL statements will be rollbackable.
Except drop database. That's one that'll probably never be rollbackable
;^)
^ permalink raw reply [nested|flat] 13+ messages in thread
* Inquiry From Form [pgsql]
@ 2003-10-10 12:50 Bram <Brambo@nextstepdev.com>
0 siblings, 0 replies; 13+ messages in thread
From: Bram @ 2003-10-10 12:50 UTC (permalink / raw)
To: info@pgsql.com
Hello,
I\'m looking for info about Join conditions in Postgre\'. I\'m head developer of ikonboard and we\'re trying to optimise it, with joins but how does this work in postgre can i download a manual anywhere?
Thanks in advanced,
Bram Wijnands
Head IB Developer
brambo@nextstepdev.com
^ permalink raw reply [nested|flat] 13+ messages in thread
end of thread, other threads:[~2003-10-10 12:50 UTC | newest]
Thread overview: 13+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2003-02-25 00:22 Inquiry From Form [pgsql] Jack Kiss <jackkiss@ecluboz.com>
2003-03-02 14:10 ` Greg Stark <gsstark@mit.edu>
2003-05-13 21:07 Inquiry From Form [pgsql] Issa <imohd@sdps.org>
2003-05-15 16:41 ` Ian Barwick <barwick@gmx.net>
2003-05-15 17:26 ` Stephan Szabo <sszabo@megazone23.bigpanda.com>
2003-05-15 02:04 Inquiry From Form [pgsql] eric <eric@vianet-express.com.br>
2003-05-15 17:27 ` Stephan Szabo <sszabo@megazone23.bigpanda.com>
2003-05-19 05:23 Inquiry From Form [pgsql] Rajendran <rajendran@davlin.co.in>
2003-05-23 11:24 Re: Inquiry From Form [pgsql] Christoph Haller <ch@rodos.fzk.de>
2003-05-23 18:29 ` Achilleus Mantzios <achill@matrix.gatewaynet.com>
2003-07-03 11:19 Re: Inquiry From Form [pgsql] Bruno Wolff III <bruno@wolff.to>
2003-07-03 16:12 ` scott.marlowe <scott.marlowe@ihs.com>
2003-10-10 12:50 Inquiry From Form [pgsql] Bram <Brambo@nextstepdev.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox