Home > mailing lists

Mailing lists [pgsql-novice]

1 June 2007

08:38 STABLE has no effect on PL/pgsql functions psql-novice@netzach.co.il
09:34 Re: STABLE has no effect on PL/pgsql functions psql-novice@netzach.co.il
09:42 Re: STABLE has no effect on PL/pgsql functions Oliver Elphick
18:05 assign null value to a field in plpgsql David Monarchi
18:22 Re: assign null value to a field in plpgsql Tom Lane
18:31 How do I insert a record into a table? Brian Hurt
19:04 Re: How do I insert a record into a table? Michael Glaesemann
19:06 Re: How do I insert a record into a table? Richard Broersma Jr
19:30 Re: How do I insert a record into a table? Derrick Betts
19:56 Re: How do I insert a record into a table? Brian Hurt
19:56 Re: How do I insert a record into a table? Brian Hurt
20:01 Re: How do I insert a record into a table? Michael Glaesemann
20:18 Feed a table function with a query Robert Wimmer
20:20 Re: How do I insert a record into a table? Brian Hurt
20:31 Re: Feed a table function with a query Derrick Betts
20:54 Re: How do I insert a record into a table? Michael Glaesemann

4 June 2007

15:05 current_date / datetime stuff Joshua
16:07 Re: current_date / datetime stuff Netzach
16:11 Re: current_date / datetime stuff Jon Sime
16:32 Re: Retreving count of rows returned by a join query David Gardner
16:43 Re: current_date / datetime stuff Michael Glaesemann
20:57 Laptop Mobo Dead...
21:06 Re: Laptop Mobo Dead... Andrej Ricnik-Bay
22:41 multidimensional array loading David Monarchi

5 June 2007

11:59 Re: JOIN Loredana Curugiu
12:18 Re: [SQL] JOIN Loredana Curugiu
13:04 Assigning Password to New created user Ashish Karalkar
13:15 Re: [SQL] JOIN Loredana Curugiu
13:18 JOIN Loredana Curugiu
13:26 Re: [SQL] JOIN Oliveiros Cristina
13:44 Re: JOIN Sean Davis
14:08 Re: [SQL] JOIN Loredana Curugiu
14:15 Re: [SQL] JOIN Loredana Curugiu
14:30 Re: [SQL] JOIN Oliveiros Cristina
14:47 Re: [SQL] JOIN Loredana Curugiu
14:52 Re: [SQL] JOIN Oliveiros Cristina
14:57 Re: [SQL] JOIN Loredana Curugiu
15:00 Re: [SQL] JOIN Oliveiros Cristina
15:11 Re: Assigning Password to New created user Oliver Elphick

6 June 2007

02:54 Installation of postgresql database as root Ali, Luqman
03:03 Re: Installation of postgresql database as root Andrej Ricnik-Bay
03:46 Re: Installation of postgresql database as root Ali, Luqman
04:03 Re: Installation of postgresql database as root Andrej Ricnik-Bay
04:12 update or insert into table from a view Phillip Nelson
04:20 Re: Installation of postgresql database as root Ali, Luqman
08:26 Re: [SQL] JOIN Loredana Curugiu
11:56 Re: Installation of postgresql database as root John DeSoi
12:46 Re: JOIN Loredana Curugiu
12:47 Re: JOIN Loredana Curugiu
14:45 Re: Installation of postgresql database as root Tom Lane
21:39 subselect syntax Steve Lefevre
23:15 Re: subselect syntax Phillip Smith
23:19 Re: subselect syntax Tom Lane
23:27 Re: subselect syntax Michael Glaesemann

7 June 2007

14:08 Query with tables from 2 different databases in Java Loredana Curugiu
14:25 Re: Query with tables from 2 different databases in Java Sean Davis
14:34 Re: [JDBC] Query with tables from 2 different databases in Java Richard Broersma Jr
14:39 Re: Query with tables from 2 different databases in Java Tomeh, Husam
15:19 Re: Query with tables from 2 different databases inJava Bart Degryse
15:50 Re: [JDBC] Query with tables from 2 different databases inJava Loredana Curugiu
15:51 Re: [JDBC] Query with tables from 2 different databases inJava Richard Broersma Jr
15:57 Re: [JDBC] Query with tables from 2 different databases inJava Sean Davis
18:43 querying the age of a row Lonni J Friedman
18:49 Re: querying the age of a row Sean Davis
18:56 Re: querying the age of a row Lonni J Friedman
19:08 Re: querying the age of a row Sean Davis
19:16 Re: querying the age of a row Lonni J Friedman
19:18 Re: querying the age of a row Lonni J Friedman
19:24 Re: querying the age of a row Sean Davis
19:43 Re: querying the age of a row Lonni J Friedman

8 June 2007

00:55 Index on timestamp fields David Gardner
01:28 Re: Index on timestamp fields Tom Lane
01:33 Re: Index on timestamp fields Richard Broersma Jr
04:11 How do I ensure a value does not exist in a column. Andrew Maclean
08:29 Re: [JDBC] Query with tables from 2 different databasesinJava Bart Degryse
14:58 Re: Index on timestamp fields David Gardner
18:20 current_date and pl/pgsql volitility David Gardner
19:06 PGPLSql Select Into problem. Gary Townsend

9 June 2007

08:48 Re: PGPLSql Select Into problem. A. Kretschmer
12:27 Re: PGPLSql Select Into problem. Michael Fuhr
14:13 Re: PGPLSql Select Into problem. A. Kretschmer
18:01 forcing pg to use an index David Monarchi
19:27 Re: forcing pg to use an index Tom Lane

11 June 2007

01:40 disallowed characters in table names? Steve Lefevre
01:52 Re: disallowed characters in table names? Michael Glaesemann
02:00 Re: disallowed characters in table names? Tom Lane
14:18 query plan and the use of indexes David Monarchi
14:35 Re: query plan and the use of indexes Tom Lane
15:42 Re: PGPLSql Select Into problem. Gary Townsend

12 June 2007

15:05 Recovering Postgres databases Andrew
22:49 no results for nextval() query? Steve Lefevre
22:59 Joins within a table Steve Lefevre
23:23 Re: Joins within a table Richard Broersma Jr
23:32 Re: Joins within a table Andrew Maclean
23:37 Re: no results for nextval() query? Richard Broersma Jr

13 June 2007

00:04 unreasonable run time for vacuum analyze? David Monarchi
00:25 Re: unreasonable run time for vacuum analyze? Richard Broersma Jr
00:51 Re: Joins within a table Tom Lane
01:14 Re: unreasonable run time for vacuum analyze? Tom Lane
02:44 inputs for pg_get_id() function? Steve Lefevre
03:56 Re: inputs for pg_get_id() function? Richard Broersma Jr
15:12 Mapping one to many Nabil
15:50 Re: Mapping one to many Michael Glaesemann
16:17 Re: Mapping one to many Nabil
17:50 Re: Mapping one to many Nabil
18:05 Re: Mapping one to many Richard Broersma Jr
18:23 Re: Mapping one to many Nabil
18:52 Re: Mapping one to many Ilan Volow
18:57 Re: Mapping one to many Richard Broersma Jr
20:53 Re: Mapping one to many Robert Wimmer

14 June 2007

05:21 Re: inputs for pg_get_id() function? Richard Broersma Jr.
05:22 Re: no results for nextval() query? Richard Broersma Jr.
18:30 cannot cast type boolean to text? Brian Hurt
18:39 Re: cannot cast type boolean to text? Tom Lane
18:41 Re: cannot cast type boolean to text? Shoaib Mir
18:43 Re: cannot cast type boolean to text? Shoaib Mir

15 June 2007

13:43 Formatting function, simple Q nhrcommu@rochester.rr.com
14:20 Re: Formatting function, simple Q Tom Lane
14:45 Re: Formatting function, simple Q nhrcommu@rochester.rr.com
18:14 Stuck (again) trying to move a 7.x app and database to 8.2 Howard Eglowstein
21:06 Re: Stuck (again) trying to move a 7.x app and database to 8.2 Tom Lane

16 June 2007

23:30 Connecting to the database via TCP/IP Guillaume Yziquel

17 June 2007

01:25 Re: Connecting to the database via TCP/IP Andrej Ricnik-Bay

18 June 2007

05:52 Correct table size when a using short integer array type. Shivin M
06:29 Re: Stuck (again) trying to move a 7.x app and database to 8.2 Tommy Gildseth
11:56 Re: Stuck (again) trying to move a 7.x app and database to 8.2 Howard Eglowstein

19 June 2007

00:56 Re: foreign key check David Gardner
00:58 foreign key check David Gardner
01:39 Re: foreign key check Tom Lane
02:02 Re: foreign key check Michael Glaesemann
08:52 Re: [GENERAL] [PERFORM] [ADMIN] Postgres VS Oracle Andrew Kelly
10:58 Re: Stuck (again) trying to move a 7.x app and database to 8.2 Eric Comeau
11:28 Re: Stuck (again) trying to move a 7.x app and database to 8.2 Eric Comeau
13:15 Re: [pgsql-advocacy] [PERFORM] [ADMIN] Postgres VS Oracle Jim Nasby

20 June 2007

04:04 Recursive relationship - preventing cross-index entries. Andrew Maclean
10:49 Re: Recursive relationship - preventing cross-index entries. Sean Davis
13:45 meaning of "create role" Carol Cheung
13:58 Re: meaning of "create role" Michael Glaesemann
14:00 Re: meaning of "create role" A. Kretschmer
15:12 Simple, Add constraint nhrcommu@rochester.rr.com
15:35 Re: meaning of "create role" Tom Lane
15:47 Re: Simple, Add constraint Richard Broersma Jr
16:05 Re: Simple, Add constraint nhrcommu@rochester.rr.com
17:02 Re: meaning of "create role" Michael Glaesemann

21 June 2007

08:18 Select last there dates Loredana Curugiu
09:50 Re: [SQL] Select last there dates A. Kretschmer
11:09 stem override, tsearch2 Marcus Engene
13:00 Re: [SQL] Select last there dates Loredana Curugiu
13:24 Re: [SQL] Select last there dates A. Kretschmer
13:33 Re: [SQL] Select last there dates Loredana Curugiu
13:35 Re: [SQL] Select last there dates Loredana Curugiu
13:48 Re: Select last there dates David Gardner
18:23 Re: stem override, tsearch2 Andrej Ricnik-Bay

22 June 2007

01:30 8.1 -- very slow query time because of "BETWEEN" (dbmail) Brian Neu
02:11 Re: 8.1 -- very slow query time because of "BETWEEN" (dbmail) Tom Lane
03:05 Re: 8.1 -- very slow query time because of "BETWEEN" (dbmail) Brian Neu
03:33 Re: 8.1 -- very slow query time because of "BETWEEN" (dbmail) Tom Lane
05:55 how to use variables in postgresql saumya goel
06:07 Re: how to use variables in postgresql A. Kretschmer
06:52 Re: how to use variables in postgresql Christoph Della Valle
09:00 Re: 8.1 -- very slow query time because of "BETWEEN" (dbmail) Brian Neu
21:19 [Fwd: replicate linux postgresql database on windows server] Mary Anderson

25 June 2007

14:30 simple SQL question Joshua
14:55 Re: simple SQL question Derrick Betts
15:25 Re: simple SQL question Glenn Davy
15:28 another simple SQL question Joshua
15:44 Re: another simple SQL question Daniel T. Staal
16:03 Re: another simple SQL question Glenn Davy
16:04 Re: another simple SQL question Derrick Betts
16:14 Re: another simple SQL question Glenn Davy
17:44 yet another simple SQL question Joshua
17:55 Re: yet another simple SQL question Derrick Betts
18:07 Re: [SQL] yet another simple SQL question A. Kretschmer
18:12 Re: yet another simple SQL question Charley Tiggs

26 June 2007

16:39 Insert Question Phillip Nelson
17:06 parameters to pl/pgSQL functions David Gardner
17:45 Re: parameters to pl/pgSQL functions Tom Lane
18:34 Re: parameters to pl/pgSQL functions David Gardner
18:38 Re: Insert Question Michael Glaesemann

27 June 2007

15:37 convert column of integer type to time type? Carol Cheung
16:22 Re: convert column of integer type to time type? Michael Glaesemann
22:09 Re: convert column of integer type to time type? Carol Cheung

28 June 2007

20:26 Query performance on session table Burak Seydioglu
21:38 Re: Query performance on session table Michael Glaesemann
23:05 Re: Query performance on session table Burak Seydioglu

29 June 2007

00:56 Re: Query performance on session table Michael Glaesemann
03:28 Re: Query performance on session table Burak Seydioglu
03:49 Re: Query performance on session table Michael Glaesemann