pgsql-sql since 2007-01-19 00:00

Discussion for users on SQL related matters.

Search the Archives

(enter a message-id to go directly to that message)

Browse Archives

Prev | Next

Jan. 19, 2007

Thread Author Time
Re: Help ... Unexpected results when using limit/offset with Stephan Szabo 00:40
Query to return schema/table/columname/columntype paallen 12:41
Re: Postgresql & Oracle Heteregenous services - strange behaviour Marcin Stępnicki 13:14
Re: Query to return schema/table/columname/columntype paallen 14:23
Re: Query to return schema/table/columname/columntype Bruno Wolff III 15:45
Re: Query to return schema/table/columname/columntype chester c young 16:28
Re: Query to return schema/table/columname/columntype codeWarrior 16:39
Permissions Query? paallen 19:11
Re: Permissions Query? Andrew Sullivan 19:15

Jan. 20, 2007

Thread Author Time
select based on multi-column primary keys mawrya 00:44
Re: select based on multi-column primary keys Bruno Wolff III 01:45
Re: select based on multi-column primary keys codeWarrior 03:45
Re: select based on multi-column primary keys Richard Broersma Jr 04:57

Jan. 21, 2007

Thread Author Time
Re: select based on multi-column primary keys Andrew Sullivan 15:28
Changing point for commas and commas for point Ezequias Rodrigues da Rocha 18:41
Re: Changing point for commas and commas for point Tom Lane 18:49
Re: Changing point for commas and commas for point Andreas Kretschmer 18:56
Possible to emulate pre-8.2 behaviour of SET CONSTRAINTS? Simon Kinsella 23:52

Jan. 22, 2007

Thread Author Time
Re: Possible to emulate pre-8.2 behaviour of SET CONSTRAINTS? Tom Lane 03:36
list variable attributes in one select Louis-David Mitterrand 07:43
Re: list variable attributes in one select A. Kretschmer 08:24
FW: Possible to emulate pre-8.2 behaviour of SET CONSTRAINTS? Simon Kinsella 10:50
server process (PID xxx) was terminated by signal 7 Achilleas Mantzios 11:12
Re: server process (PID xxx) was terminated by signal 7 Tom Lane 16:01
Re: server process (PID xxx) was terminated by signal 7 Alvaro Herrera 16:47
Re: server process (PID xxx) was terminated by signal Bruce Momjian 17:27
Schema sample Ezequias Rodrigues da Rocha 19:38
Re: Schema sample Marcin Stępnicki 19:45
Re: Schema sample Aaron Bono 19:54
How to query by column names Richard Ray 22:25
Re: How to query by column names Jeff Frost 23:29
Re: How to query by column names Richard Ray 23:58

Jan. 23, 2007

Thread Author Time
Re: How to query by column names Jeff Frost 00:20
Re: How to query by column names Richard Ray 00:30
Re: How to query by column names Jeff Frost 00:36
Re: How to query by column names Richard Ray 01:25
Re: How to query by column names Jeff Frost 01:32
Re: How to query by column names Josh Williams 05:03
Re: How to query by column names Jeff Frost 05:29
Re: server process (PID xxx) was terminated by signal 7 Achilleas Mantzios 08:52
Re: How to query by column names John Summerfield 11:56
Re: How to query by column names John Summerfield 12:01
Odbc configuration on Localhost Ezequias Rodrigues da Rocha 14:35
Re: Odbc configuration on Localhost Oisin Glynn 14:52
Re: select based on multi-column primary keys codeWarrior 21:07
Re: select based on multi-column primary keys Andrew Sullivan 21:26
Re: server process (PID xxx) was terminated by signal Peter Eisentraut 23:26

Jan. 24, 2007

Thread Author Time
Re: server process (PID xxx) was terminated by signal 7 Achilleas Mantzios 08:47

Jan. 25, 2007

Thread Author Time
Using Temporary Tables in postgres functions Mario Splivalo 14:39
Re: Using Temporary Tables in postgres functions Andrew Sullivan 16:00
Re: Using Temporary Tables in postgres functions Stephan Szabo 16:03
Re: Using Temporary Tables in postgres functions Tom Lane 16:09
Windows 2K Installation difficulties... Neil Bibbins 16:53
Re: Windows 2K Installation difficulties... Oisin Glynn 18:28
Looping recordset Furesz Peter 19:45
shared_buffers and shmall,shmmax Jie Liang 20:11
Re: shared_buffers and shmall,shmmax Tom Lane 20:14
Re: shared_buffers and shmall,shmmax Jie Liang 20:58
LEFT Join Question Rob V 23:51

Jan. 26, 2007

Thread Author Time
Re: LEFT Join Question Rob V 00:09
Re: Looping recordset Hélder M. Vieira 00:56
Re: LEFT Join Question codeWarrior 02:13
Intersection of two date interval Suha Onay 09:39
implementing (something like) UNIQUE constraint using PL/pgSQL Tomas Vondra 09:41
Re: Intersection of two date interval A. Kretschmer 09:50
Re: Intersection of two date interval Achilleas Mantzios 10:02
Re: Using Temporary Tables in postgres functions Mario Splivalo 10:46
Re: Using Temporary Tables in postgres functions Mario Splivalo 10:47
Re: Using Temporary Tables in postgres functions Mario Splivalo 10:51
Evaluate a variable Luís Sousa 11:58
Re: LEFT Join Question Andrew Sullivan 12:58
Re: Evaluate a variable Alvaro Herrera 14:19
Re: LEFT Join Question Rob V 14:44
Re: Using Temporary Tables in postgres functions Tom Lane 14:57
Function returning SETOF using plpythonu Luís Sousa 17:24
Re: Intersection of two date interval Bruno Wolff III 20:11
Re: Function returning SETOF using plpythonu Marcin Stępnicki 22:17
Re: [NOVICE] Windows 2K Installation difficulties... Oisin Glynn 23:25

Jan. 27, 2007

Thread Author Time
Re: implementing (something like) UNIQUE constraint using PL/pgSQL Bruno Wolff III 07:55
Re: implementing (something like) UNIQUE constraint using PL/pgSQL Michael Glaesemann 11:58

Jan. 28, 2007

Thread Author Time
Re: [ADMIN] server process (PID xxx) was terminated by signal 📎 Bruce Momjian 01:15
Re: [ADMIN] server process (PID xxx) was Bruce Momjian 01:32
Re: [ADMIN] server process (PID xxx) was Tom Lane 02:24
Re: [ADMIN] server process (PID xxx) was Bruce Momjian 02:33
Re: [ADMIN] server process (PID xxx) was Tom Lane 05:24
Re: [ADMIN] server process (PID xxx) was terminated by signal Peter Eisentraut 10:05
Re: [ADMIN] server process (PID xxx) was Bruce Momjian 14:05
Re: [ADMIN] server process (PID xxx) was Bruce Momjian 14:06
Re: [ADMIN] server process (PID xxx) was terminated by signal Peter Eisentraut 14:22
Re: [ADMIN] server process (PID xxx) was Bruce Momjian 14:28
Re: [ADMIN] server process (PID xxx) was terminated by signal Tom Lane 15:00
Re: [ADMIN] server process (PID xxx) was terminated by signal Peter Eisentraut 17:21
Re: [ADMIN] server process (PID xxx) was Bruce Momjian 22:02
Re: [ADMIN] server process (PID xxx) was David Fetter 23:36

Jan. 29, 2007

Thread Author Time
Very strange postgresql behaviour Arnau 12:21
Re: Very strange postgresql behaviour Andrew Sullivan 13:00
Re: Function returning SETOF using plpythonu Luís Sousa 14:12
Re: Function returning SETOF using plpythonu Adrian Klaver 14:29
Re: [ADMIN] server process (PID xxx) was 📎 Bruce Momjian 20:21
Re: [ADMIN] server process (PID xxx) was Bruce Momjian 21:02

Jan. 30, 2007

Thread Author Time
Differentiate Between Zero-Length String and NULL Column Values 📎 Phillip Smith 05:32
Re: Differentiate Between Zero-Length String and NULL Column Values Michael Fuhr 05:45
Arrays, multidimensional ANY (v 8.2) Niklas Bergius 10:40
Re: Differentiate Between Zero-Length String and NULL Column Values Andrew Sullivan 13:13
Re: Differentiate Between Zero-Length String and NULLColumn Values Bart Degryse 13:38
Re: Differentiate Between Zero-Length String and NULLColumn Values Andrew Sullivan 14:23
Re: Differentiate Between Zero-Length String and NULLColumn Values Herouth Maoz 14:37
Linked Databases Ezequias Rodrigues da Rocha 15:36
Re: Differentiate Between Zero-Length String and NULLColumn Values D'Arcy J.M. Cain 16:38
Re: Differentiate Between Zero-Length String and NULLColumn Values Andrew Sullivan 16:55
Log, Logs and more Logs Ezequias Rodrigues da Rocha 17:01
Re: Log, Logs and more Logs Andrew Sullivan 17:26
Re: Differentiate Between Zero-Length String and NULLColumn Values Geoff Tolley 18:14
Re: Log, Logs and more Logs Ezequias Rodrigues da Rocha 18:41
Re: Differentiate Between Zero-Length String and NULLColumn Values Peter Eisentraut 18:59
Re: Differentiate Between Zero-Length String and NULLColumn Values Tomas Vondra 19:34
Re: Differentiate Between Zero-Length String and NULLColumn Values Jamie A Lawrence 20:17
Index ANDing & Index ORing Hiltibidal, Robert 20:42
Re: Log, Logs and more Logs Andrew Sullivan 21:33

Jan. 31, 2007

Thread Author Time
Re: Log, Logs and more Logs Ezequias Rodrigues da Rocha 11:35
Re: Log, Logs and more Logs Shoaib Mir 11:39
Re: Log, Logs and more Logs Ezequias Rodrigues da Rocha 12:04
Re: Log, Logs and more Logs Ezequias Rodrigues da Rocha 12:12
Re: Log, Logs and more Logs imad 12:18
Re: Log, Logs and more Logs Shoaib Mir 12:19
Re: Log, Logs and more Logs Joe 12:21
Re: Log, Logs and more Logs Ezequias Rodrigues da Rocha 12:29
Re: Log, Logs and more Logs Ezequias Rodrigues da Rocha 12:39
Re: Log, Logs and more Logs Shoaib Mir 12:51
Re: Log, Logs and more Logs Ezequias Rodrigues da Rocha 13:38
Re: Log, Logs and more Logs Shoaib Mir 13:46
Index Anding Hiltibidal, Robert 14:56
Re: Index Anding Andrew Sullivan 15:52
Re: Index Anding Hiltibidal, Robert 16:39
Re: Log, Logs and more Logs Ezequias Rodrigues da Rocha 19:49
Re: Differentiate Between Zero-Length String and NULLColumn Values BillR 20:18

Feb. 1, 2007

Thread Author Time
Compilation errors Hiltibidal, Robert 15:10
Compilation Error AIX Hiltibidal, Robert 15:33
Re: Compilation Error AIX Andrew Sullivan 15:48
Re: Insert Data and autonumeric field Andrew Sullivan 18:13
Re: Insert Data and autonumeric field Tom Lane 18:32
Re: Differentiate Between Zero-Length String and NULLColumn Values Andrew Sullivan 18:53
Insert Data and autonumeric field André José Guergolet 19:09
Search a range of cases/records Wei ZOU 20:56
Re: Index Anding Chris Browne 22:45
Re: Index Anding Hiltibidal, Robert 23:13

Feb. 2, 2007

Thread Author Time
sql Shyju Narayanan 07:39
Insert into a date field Ezequias Rodrigues da Rocha 13:08
Re: Insert into a date field Richard Huxton 13:12
Re: Insert into a date field Shoaib Mir 13:45
Duplicate records Ezequias Rodrigues da Rocha 13:48
Re: Insert into a date field Ezequias Rodrigues da Rocha 13:49
Re: Duplicate records Mezei Zoltán 13:54
Re: Duplicate records Shoaib Mir 13:55
Re: Duplicate records Bart Degryse 13:55
Re: Duplicate records Ezequias Rodrigues da Rocha 13:59
Re: Duplicate records Shoaib Mir 14:03
Re: Duplicate records Bart Degryse 14:13
Re: Insert into a date field Hiltibidal, Robert 14:56
Re: Duplicate records Ezequias Rodrigues da Rocha 15:00
Re: Duplicate records Andrew Sullivan 15:16
Nocount and scope_identity() Demel, Jeff 17:49
to_chat(bigint) Ezequias Rodrigues da Rocha 18:11
Re: to_chat(bigint) Bricklen Anderson 18:15
Re: Nocount and scope_identity() Andrew Sullivan 18:18
Re: Nocount and scope_identity() Demel, Jeff 19:38
Question regarding multibyte. Karthikeyan Sundaram 19:51
Re: Nocount and scope_identity() Andrew Sullivan 19:57
Re: Nocount and scope_identity() Tom Lane 20:28

Feb. 4, 2007

Thread Author Time
Re: [SQL] Question regarding multibyte. Karthikeyan Sundaram 21:34
Re: [PHP] [SQL] Question regarding multibyte. Michael Fuhr 22:30
Re: [SQL] Question regarding multibyte. Charley Tiggs 22:44
Re: [SQL] Question regarding multibyte. Ivo Rossacher 23:26
Getting associated columns with max() without subquery César Antonio León Mansilla 23:30

Feb. 5, 2007

Thread Author Time
PL/pgsql declaration of string / bit / number with given (variable!) length sneumann 16:02
Symbol lookup error Karthikeyan Sundaram 21:37
Re: Symbol lookup error Tom Lane 21:49

Feb. 6, 2007

Thread Author Time
Re: sql A. Kretschmer 06:41
Re: Search a range of cases/records A. Kretschmer 06:58
Re: sql Karthikeyan Sundaram 07:16
Re: sql Penchalaiah P. 08:41
Re: Index ANDing & Index ORing Richard Huxton 09:38
Re: Compilation errors Richard Huxton 09:39
Re: PL/pgsql declaration of string / bit / number with given (variable!) length Richard Huxton 09:45
Re: Index ANDing & Index ORing Richard Huxton 13:16
Re: Index ANDing & Index ORing Richard Huxton 14:05
Re: Compilation Error AIX Alvaro Herrera 14:07
Removing duplicate rows Paul Lambert 22:15
Re: Removing duplicate rows Andrew Sullivan 22:22
Re: Removing duplicate rows Paul Lambert 22:44
Re: Removing duplicate rows Hélder M. Vieira 22:49
Re: Removing duplicate rows Thomas Kellerer 23:15

Feb. 7, 2007

Thread Author Time
interval as hours or minutes ? Aarni Ruuhimäki 17:03
Re: interval as hours or minutes ? Bricklen Anderson 17:33
Re: interval as hours or minutes ? A. Kretschmer 17:44
metaphone and nysiis in postgres Demel, Jeff 19:46
Re: metaphone and nysiis in postgres Tom Lane 20:08
Re: metaphone and nysiis in postgres Demel, Jeff 20:13
Re: metaphone and nysiis in postgres Demel, Jeff 20:31
Re: interval as hours or minutes ? Bruno Wolff III 21:25

Browse Archives

Prev | Next