Home > mailing lists

Mailing lists [pgsql-novice]

1 June 2007

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

4 June 2007

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

5 June 2007

08:59 Re: JOIN Loredana Curugiu
09:18 Re: [SQL] JOIN Loredana Curugiu
10:04 Assigning Password to New created user Ashish Karalkar
10:15 Re: [SQL] JOIN Loredana Curugiu
10:18 JOIN Loredana Curugiu
10:26 Re: [SQL] JOIN Oliveiros Cristina
10:44 Re: JOIN Sean Davis
11:08 Re: [SQL] JOIN Loredana Curugiu
11:15 Re: [SQL] JOIN Loredana Curugiu
11:30 Re: [SQL] JOIN Oliveiros Cristina
11:47 Re: [SQL] JOIN Loredana Curugiu
11:52 Re: [SQL] JOIN Oliveiros Cristina
11:57 Re: [SQL] JOIN Loredana Curugiu
12:00 Re: [SQL] JOIN Oliveiros Cristina
12:11 Re: Assigning Password to New created user Oliver Elphick
23:54 Installation of postgresql database as root Ali, Luqman

6 June 2007

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

7 June 2007

11:08 Query with tables from 2 different databases in Java Loredana Curugiu
11:25 Re: Query with tables from 2 different databases in Java Sean Davis
11:34 Re: [JDBC] Query with tables from 2 different databases in Java Richard Broersma Jr
11:39 Re: Query with tables from 2 different databases in Java Tomeh, Husam
12:19 Re: Query with tables from 2 different databases inJava Bart Degryse
12:50 Re: [JDBC] Query with tables from 2 different databases inJava Loredana Curugiu
12:51 Re: [JDBC] Query with tables from 2 different databases inJava Richard Broersma Jr
12:57 Re: [JDBC] Query with tables from 2 different databases inJava Sean Davis
15:43 querying the age of a row Lonni J Friedman
15:49 Re: querying the age of a row Sean Davis
15:56 Re: querying the age of a row Lonni J Friedman
16:08 Re: querying the age of a row Sean Davis
16:16 Re: querying the age of a row Lonni J Friedman
16:18 Re: querying the age of a row Lonni J Friedman
16:24 Re: querying the age of a row Sean Davis
16:43 Re: querying the age of a row Lonni J Friedman
21:55 Index on timestamp fields David Gardner
22:28 Re: Index on timestamp fields Tom Lane
22:33 Re: Index on timestamp fields Richard Broersma Jr

8 June 2007

01:11 How do I ensure a value does not exist in a column. Andrew Maclean
05:29 Re: [JDBC] Query with tables from 2 different databasesinJava Bart Degryse
11:58 Re: Index on timestamp fields David Gardner
15:20 current_date and pl/pgsql volitility David Gardner
16:06 PGPLSql Select Into problem. Gary Townsend

9 June 2007

05:48 Re: PGPLSql Select Into problem. A. Kretschmer
09:27 Re: PGPLSql Select Into problem. Michael Fuhr
11:13 Re: PGPLSql Select Into problem. A. Kretschmer
15:01 forcing pg to use an index David Monarchi
16:27 Re: forcing pg to use an index Tom Lane

10 June 2007

22:40 disallowed characters in table names? Steve Lefevre
22:52 Re: disallowed characters in table names? Michael Glaesemann
23:00 Re: disallowed characters in table names? Tom Lane

11 June 2007

11:18 query plan and the use of indexes David Monarchi
11:35 Re: query plan and the use of indexes Tom Lane
12:42 Re: PGPLSql Select Into problem. Gary Townsend

12 June 2007

12:05 Recovering Postgres databases Andrew
19:49 no results for nextval() query? Steve Lefevre
19:59 Joins within a table Steve Lefevre
20:23 Re: Joins within a table Richard Broersma Jr
20:32 Re: Joins within a table Andrew Maclean
20:37 Re: no results for nextval() query? Richard Broersma Jr
21:04 unreasonable run time for vacuum analyze? David Monarchi
21:25 Re: unreasonable run time for vacuum analyze? Richard Broersma Jr
21:51 Re: Joins within a table Tom Lane
22:14 Re: unreasonable run time for vacuum analyze? Tom Lane
23:44 inputs for pg_get_id() function? Steve Lefevre

13 June 2007

00:56 Re: inputs for pg_get_id() function? Richard Broersma Jr
12:12 Mapping one to many Nabil
12:50 Re: Mapping one to many Michael Glaesemann
13:17 Re: Mapping one to many Nabil
14:50 Re: Mapping one to many Nabil
15:05 Re: Mapping one to many Richard Broersma Jr
15:23 Re: Mapping one to many Nabil
15:52 Re: Mapping one to many Ilan Volow
15:57 Re: Mapping one to many Richard Broersma Jr
17:53 Re: Mapping one to many Robert Wimmer

14 June 2007

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

15 June 2007

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

16 June 2007

20:30 Connecting to the database via TCP/IP Guillaume Yziquel
22:25 Re: Connecting to the database via TCP/IP Andrej Ricnik-Bay

18 June 2007

02:52 Correct table size when a using short integer array type. Shivin M
03:29 Re: Stuck (again) trying to move a 7.x app and database to 8.2 Tommy Gildseth
08:56 Re: Stuck (again) trying to move a 7.x app and database to 8.2 Howard Eglowstein
21:56 Re: foreign key check David Gardner
21:58 foreign key check David Gardner
22:39 Re: foreign key check Tom Lane
23:02 Re: foreign key check Michael Glaesemann

19 June 2007

05:52 Re: [GENERAL] [PERFORM] [ADMIN] Postgres VS Oracle Andrew Kelly
07:58 Re: Stuck (again) trying to move a 7.x app and database to 8.2 Eric Comeau
08:28 Re: Stuck (again) trying to move a 7.x app and database to 8.2 Eric Comeau
10:15 Re: [pgsql-advocacy] [PERFORM] [ADMIN] Postgres VS Oracle Jim Nasby

20 June 2007

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

21 June 2007

05:18 Select last there dates Loredana Curugiu
06:50 Re: [SQL] Select last there dates A. Kretschmer
08:09 stem override, tsearch2 Marcus Engene
10:00 Re: [SQL] Select last there dates Loredana Curugiu
10:24 Re: [SQL] Select last there dates A. Kretschmer
10:33 Re: [SQL] Select last there dates Loredana Curugiu
10:35 Re: [SQL] Select last there dates Loredana Curugiu
10:48 Re: Select last there dates David Gardner
15:23 Re: stem override, tsearch2 Andrej Ricnik-Bay
22:30 8.1 -- very slow query time because of "BETWEEN" (dbmail) Brian Neu
23:11 Re: 8.1 -- very slow query time because of "BETWEEN" (dbmail) Tom Lane

22 June 2007

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

25 June 2007

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

26 June 2007

13:39 Insert Question Phillip Nelson
14:06 parameters to pl/pgSQL functions David Gardner
14:45 Re: parameters to pl/pgSQL functions Tom Lane
15:34 Re: parameters to pl/pgSQL functions David Gardner
15:38 Re: Insert Question Michael Glaesemann

27 June 2007

12:37 convert column of integer type to time type? Carol Cheung
13:22 Re: convert column of integer type to time type? Michael Glaesemann
19:09 Re: convert column of integer type to time type? Carol Cheung

28 June 2007

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

29 June 2007

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