pgsql-sql since 1998-07-31 00:00

Discussion for users on SQL related matters.

Search the Archives

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

Browse Archives

Prev | Next

July 31, 1998

Thread Author Time
Re: [SQL] What do I need to escape in an Insert ? Dan Delaney 04:42
Re: [SQL] What do I need to escape in an Insert ? Bruce Momjian 05:01
sample database file . . 06:40
Re: [SQL] What do I need to escape in an Insert ? Daniele Orlandi 12:26
Query from 2 data base Roberto Joao Lopes Garcia 14:04
pg_time Stuart logan 14:41
Re: [SQL] sample database file Leslie Mikesell 16:12
locked my keys in the car Thomas Good 18:03
Re: [SQL] What do I need to escape in an Insert ? Richard Lynch 18:21
Back-up through SQL!!!! G.Elangovan 18:58
FOREIGN KEY Alexey Pushkin 20:07
RE: [SQL] FOREIGN KEY Jackson, DeJuan 22:58

Aug. 1, 1998

Thread Author Time
Authentication Problems G.Elangovan 00:15
date versus datetime? Eric McKeown 02:59
Re: [SQL] locked my keys in the car Federico Passaro 05:58
Re: [SQL] pg_time Marc Howard Zuckman 14:31
Re: date versus datetime? Tom Lane 20:16
Re: [ADMIN] Authentication Problems Peter T Mount 22:48

Aug. 2, 1998

Thread Author Time
int/bit fields Sascha Schumann 15:26
unsubscribe Roman Volkoff 16:46

Aug. 3, 1998

Thread Author Time
Converting a Sybase SQL script to a PostgreSQL script David Rugge 00:52
aggregates Jade 03:19
Date format DD-MMM-YYYY Chairudin Sentosa Harjo 03:32
Re: [SQL] locked my keys in the car Thomas Good 13:10
Re: [SQL] locked my keys in the car Federico Passaro 14:01
Re: how do I update a field with a particular oid? Tom Lane 14:07
can a column be aliased? James Olin Oden 16:04
subqueries v. joins (locked my keys in the car) Thomas Good 16:52
Re: [SQL] can a column be aliased? D'Arcy J.M. Cain 17:17
Low level socket locking... M Simms 17:35
Re: [SQL] can a column be aliased? James Olin Oden 17:35
Re: [SQL] locked my keys in the car Phil R Lawrence 17:43
password protection All Of Us 17:55
Re: [SQL] Low level socket locking... dave madden 18:01
Re: [SQL] Low level socket locking... Daniele Orlandi 18:51
Re: [SQL] locked my keys in the car John Edstrom 18:54
Re: [SQL] can a column be aliased? Roderick A. Anderson 18:56
Re: [SQL] locked my keys in the car Richard Lynch 20:11
Re: [SQL] locked my keys in the car Thomas Good 20:41
inheritance question Eric McKeown 22:33

Aug. 4, 1998

Thread Author Time
JDBC line count in query result Bernhard Ertl 07:16
Re: [SQL] can a column be aliased? D'Arcy J.M. Cain 11:12
Re: [SQL] can a column be aliased? D'Arcy J.M. Cain 11:38
Re: [SQL] can a column be aliased? James Olin Oden 12:26
Which index is better for join operations Chris Williams 13:44
Query based on date/time field William McCracken 14:09
Re: [SQL] Which index is better for join operations Vadim Mikheev 14:16
binary boolean operators Sergei Barbarash 15:37
subscribe pgsql-sql chris yambo 16:07
Re: [INTERFACES] JDBC line count in query result Peter T Mount 17:48
Re: [SQL] locked my keys in the car Thomas Good 19:15
importing a pre sql db SierraAdm 21:38

Aug. 5, 1998

Thread Author Time
Re: [SQL] importing a pre sql db Leslie Mikesell 05:15
offtopic question regarding tools. Walter St. John 06:15
Re: [SQL] importing a pre sql db Maarten Boekhold 07:04
How do I get the list of table names in db James Andrews 07:38
Instaling PostgreSQL 6.3.2 for Linux Stuart logan 12:02
Pg.pm on NT William McCracken 12:13
Re: [SQL] Pg.pm on NT Maarten Boekhold 13:25
Create view and group bz problems Polášek Robert 13:26
Re: [SQL] How do I get the list of table names in db Maarten Boekhold 13:31
cursor results count Sergei Barbarash 13:35
Multiple table selection. Colin Dick 15:37
Re: [SQL] How do I get the list of table names in db James Olin Oden 15:49
More on... Multiple table selection. (fwd) Colin Dick 16:24
What is the recommended machine configuration? G. Anthony Reina 20:01
mere millimetres away Thomas Good 20:15
Re: [SQL] What is the recommended machine configuration? pierre 20:52
Re: [SQL] What is the recommended machine configuration? The Hermit Hacker 21:35
Creating table with unique key. Colin Dick 21:49
Re: [SQL] What is the recommended machine configuration? Brook Milligan 22:30
Re: [SQL] What is the recommended machine configuration? The Hermit Hacker 22:45
Re: [SQL] Creating table with unique key. Eric McKeown 22:46
Re: mere millimetres away Richard Lynch 22:47
Re: [SQL] Creating table with unique key. Richard Lynch 23:42

Aug. 6, 1998

Thread Author Time
Re: [SQL] What is the recommended machine configuration? D'Arcy J.M. Cain 00:07
How do I split the data files into 2 hardisks? Chairudin Sentosa Harjo 02:03
Re: [SQL] How do I split the data files into 2 hardisks? Ludovic Marcotte 02:13
Re: [SQL] How do I split the data files into 2 hardisks? Gene Selkov, Jr. 05:24
UNSUBSCRIBE Ricardo Romero 05:46
How do I stop the postmaster? Chairudin Sentosa Harjo 06:42
hacks to compute median values? Chris Waterson 06:45
Re: [SQL] Instaling PostgreSQL 6.3.2 for Linux rony khoury 07:23
Installing PostgreSQL 6.3.2 on Linux Stuart logan 08:37
Re: [SQL] Creating table with unique key. Tom Good 12:16
Re: [SQL] What is the recommended machine configuration? Tom Good 12:20
Re: [SQL] Creating table with unique key. Sferacarta Software 14:09
Re: [SQL] What is the recommended machine configuration? Chris Johnson 14:38
Re: [SQL] How do I split the data files into 2 hardisks? Maarten Boekhold 14:45
Re: [SQL] Creating table with unique key. pierre 15:39
Re: [SQL] How do I stop the postmaster? James Olin Oden 17:43

Aug. 7, 1998

Thread Author Time
Re: [SQL] What is the recommended machine configuration? Johann Spies 08:55

Aug. 9, 1998

Thread Author Time
MS Access via ODBC Taral 18:47

Aug. 10, 1998

Thread Author Time
Installing PostgreSQL 6.3.2 On Linux Stuart logan 09:01
'if' decision making in an SQL statement nik 10:23
Re: [SQL] Installing PostgreSQL 6.3.2 On Linux James Oden 10:51
Re: [SQL] MS Access via ODBC David Hartwig 12:00
[No subject] pgsql 13:30

Aug. 12, 1998

Thread Author Time
Re: [SQL] Installing PostgreSQL 6.3.2 On Linux rony khoury 06:54
Subquery problems Jerome Knobl 08:15
Re: [SQL] Subquery problems Marc Howard Zuckman 11:33
Re: [SQL] Query based on date/time field Herouth Maoz 12:25
Re: [SQL] Query based on date/time field Aleksey Dashevsky 12:47
Re: [SQL] Query based on date/time field Holger Mitterwald 12:50
Re: [SQL] Subquery problems Dimitri 12:59
returning the current date in a SQL query Walt Bigelow 18:31
Re: [SQL] returning the current date in a SQL query Dimitri 19:29
Re: [SQL] returning the current date in a SQL query Bruce Momjian 19:42
Cursors in Functions Dirk Elmendorf 20:31
Re: [SQL] returning the current date in a SQL query Walt Bigelow 21:07

Aug. 14, 1998

Thread Author Time
test subscribed Karin Probost 07:23
Lock vs Update Chairudin Sentosa Harjo 07:58
[No subject] postgres 13:43
pgsql-sql Linda Chow 18:46

Aug. 15, 1998

Thread Author Time
(no subject) Dariusz Owczarek 17:32

Aug. 16, 1998

Thread Author Time
Re: [SQL] returning the current date in a SQL query Herouth Maoz 11:17

Aug. 17, 1998

Thread Author Time
function year! Jerome Knobl 08:59
How create an index on a timespamp col! Jerome Knobl 09:21
Re: [SQL] function year! Herouth Maoz 09:28

Aug. 18, 1998

Thread Author Time
The use of sequences 📎 Roy Sigurd Karlsbakk 14:40
Re: [GENERAL] The use of sequences Herouth Maoz 15:27
Re: [GENERAL] The use of sequences 📎 Jeremiah Davis 15:54

Aug. 19, 1998

Thread Author Time
Cannot read block 0 Toni Steinhauer 02:12
Sub-select problem (or bug?) Mark Dalphin 03:42
CASE and functions are not working Ivan Kirillov 09:56
Appending arrays in a table G. Anthony Reina 16:58

Aug. 20, 1998

Thread Author Time
problem with LIKE predicate and wildcards Steve Maring 13:50
CHECK and IN (Sets in general) - What's the story? k_ogorman 14:12

Aug. 21, 1998

Thread Author Time
Re: [SQL] CHECK and IN (Sets in general) - What's the story? Holger Mitterwald 07:30
SQL statement Problem Chauncey Thorn 12:38
Implementing transactions (reference) Fred C. Richards 16:26
Triggers VS Rules Jose David Martinez Cuevas 19:13

Aug. 24, 1998

Thread Author Time
Subselect in DELETE Mark Dalphin 01:11
Maximum field in a table G.Elangovan 16:20
Maximum field in a table G.Elangovan 16:23
Cursors out of a transaction David Prieto Carrellan 16:38
parts of date_part() Eric McKeown 23:33

Aug. 25, 1998

Thread Author Time
this one's simpler Eric McKeown 00:06
copy probs Cho Yan Wong 02:17
Re: [SQL] this one's simpler Maarten Boekhold 07:40
Re: [SQL] copy probs Jose David Martinez Cuevas 15:22
Query otimizing possible? Andreas Schmidt 15:45
Re: [SQL] parts of date_part() Brook Milligan 17:20
Having problems to compile SPI Jose David Martinez Cuevas 18:07
RE: [SQL] Having problems to compile SPI Taral 18:26
Date vs. Datetime boundaries Leslie Mikesell 20:52
excel vs. money data type? Leslie Mikesell 21:55
copying rows Walt Bigelow 22:38
Once again... triggers 📎 Jose David Martinez Cuevas 23:52

Aug. 26, 1998

Thread Author Time
Indexing datetime Sergei Barbarash 06:51
Re: [SQL] copying rows Herouth Maoz 08:48
Re: [SQL] parts of date_part() Herouth Maoz 08:57
Re: [SQL] excel vs. money data type? David Hartwig 12:54
Re: [SQL] excel vs. money data type? Leslie Mikesell 15:15
Re: [SQL] parts of date_part() Leslie Mikesell 16:53
How do I ??? Ian Johnston 20:15
Bug in GROUP BY for INSERT Pushkar Piggott 23:34

Aug. 27, 1998

Thread Author Time
Another bug in GROUP BY for INSERT Pushkar Piggott 01:00
Re: [SQL] parts of date_part() Herouth Maoz 08:13
Counter ADM. Diego Cueva 14:13
copy one to many? Walt Bigelow 19:38
Re: [SQL] copy one to many? Bryan White 19:56
Absolute value on int2 or int4 field Chris Johnson 22:35

Aug. 28, 1998

Thread Author Time
Re: [SQL] copy one to many? Walt Bigelow 03:06
Re: [SQL] Absolute value on int2 or int4 field Guido Piazzi 08:52
Contertine timespan to hours Shawn T. Walker 18:17

Aug. 30, 1998

Thread Author Time
Re: [SQL] Contertine timespan to hours Herouth Maoz 08:40
Re: [SQL] copy one to many? Herouth Maoz 08:58

Aug. 31, 1998

Thread Author Time
Re: [SQL] copy probs Cho Yan Wong 00:36
[No subject] 📎 Johan.F.Strand 11:47

Sept. 1, 1998

Thread Author Time
upper() and lower() on varchar Maarten Boekhold 10:04
pgaccess-forms. Johann Spies 11:57
Re: [SQL] How to Make Case InSensitive??? Marcio Macedo 14:14
How to Make Case InSensitive??? S.Ramaswamy 16:02
Re: [SQL] How to Make Case InSensitive??? David Hartwig 16:21
rename table - primary key index? Leslie Mikesell 17:24
Re: [SQL] How to Make Case InSensitive??? David Hartwig 17:47

Sept. 2, 1998

Thread Author Time
indexing datetime Sergei Barbarash 07:07
Re: [SQL] upper() and lower() on varchar Sferacarta Software 12:33
Re: [SQL] upper() and lower() on varchar Maarten Boekhold 13:40
Help with setting up table and importing data. Ronnie Doggart 16:48

Sept. 3, 1998

Thread Author Time
Forming Query Ronnie Doggart 11:56
Resp: [SQL] Concatenation in selects Fidelis Assis 12:17
Concatenation in selects James Olin Oden 13:22
Re: [SQL] Concatenation in selects James Olin Oden 14:16
indexing datetime Sergei Barbarash 15:11
Resp: RE: Resp: [SQL] Concatenation in selects Fidelis Assis 17:54
RE: [SQL] rename table - primary key index? Jackson, DeJuan 18:29
RE: Resp: [SQL] Concatenation in selects Jackson, DeJuan 18:45
Re: [SQL] Concatenation in selects Leslie Mikesell 19:33

Sept. 4, 1998

Thread Author Time
Re: [SQL] Concatenation in selects Bruce Momjian 01:04
Re: [SQL] Forming Query Federico Passaro 08:57
[SQL] composite primary keys. Stuart Rison 14:21
Re: [SQL] composite primary keys. Dave 14:49
DECLARE BINARY CURSOR problem G. Anthony Reina 18:38

Sept. 5, 1998

Thread Author Time
Creating Indexes for MAC and IP Data Types 📎 Craig Orsinger 00:15
Re: [SQL] Creating Indexes for MAC and IP Data Types Bruce Momjian 01:47
Re: [SQL] Creating Indexes for MAC and IP Data Types The Hermit Hacker 04:33
constraints don't work... Andrew M Tracey 18:23

Sept. 6, 1998

Thread Author Time
Datetime in humane format Richard Lynch 04:27

Browse Archives

Prev | Next