comp.databases.postgresql.sql

Concurrency problem

Started on 03 Oktober 2004 12:58
Last reply by mha on 04 Oktober 2004 13:39
[ Posts: 3 ] [ Views: 2347 ]

How to convert 3 colums to timestamp with timezone

Started on 03 Oktober 2004 22:50
Last reply by Bruno on 04 Oktober 2004 01:42
[ Posts: 1 ] [ Views: 729 ]

Re: Postgres Doubt

Started on 03 Oktober 2004 17:50
Last reply by desoi on 03 Oktober 2004 17:50
[ Posts: 0 ] [ Views: 601 ]

psql variable interpolation from command line

Started on 01 Oktober 2004 15:24
Last reply by Jeff Boes on 01 Oktober 2004 15:28
[ Posts: 1 ] [ Views: 610 ]

multi column foreign key for implicitly unique columns

Started on 17 August 2004 11:25
Last reply by achill on 30 September 2004 12:51
[ Posts: 44 ] [ Views: 4030 ]

multiple insert

Started on 29 September 2004 19:12
Last reply by fve on 29 September 2004 19:12
[ Posts: 0 ] [ Views: 712 ]

Porting problem from Informix to Postgres...

Started on 22 September 2004 14:17
Last reply by gaio on 29 September 2004 15:21
[ Posts: 4 ] [ Views: 1035 ]

CHECK col A not NULL if col B='x'

Started on 28 September 2004 16:02
Last reply by tgl on 29 September 2004 00:36
[ Posts: 5 ] [ Views: 564 ]

Re: Doubt

Started on 28 September 2004 22:39
Last reply by Paul on 28 September 2004 22:39
[ Posts: 0 ] [ Views: 571 ]

Best way to know if there is a row

Started on 28 September 2004 14:55
Last reply by tgl on 28 September 2004 16:24
[ Posts: 2 ] [ Views: 567 ]

Re: postgres rpm

Started on 27 September 2004 08:31
Last reply by Sad on 27 September 2004 15:12
[ Posts: 1 ] [ Views: 735 ]

Re: Problem with functions

Started on 27 September 2004 02:34
Last reply by sszabo on 27 September 2004 02:34
[ Posts: 0 ] [ Views: 623 ]

where clause on a left outer join

Started on 22 September 2004 11:08
Last reply by sszabo on 27 September 2004 02:21
[ Posts: 1 ] [ Views: 633 ]

plpgsql - accessing fields of record type

Started on 26 September 2004 18:15
Last reply by Mike on 26 September 2004 20:33
[ Posts: 1 ] [ Views: 1385 ]

select column by position

Started on 24 September 2004 13:50
Last reply by chester on 24 September 2004 23:00
[ Posts: 1 ] [ Views: 811 ]

Re: [GENERAL] need ``row number``

Started on 24 September 2004 22:34
Last reply by gsstark on 24 September 2004 22:34
[ Posts: 0 ] [ Views: 577 ]

How to insert values in bytea?

Started on 24 September 2004 17:39
Last reply by oliver_nol on 24 September 2004 17:39
[ Posts: 0 ] [ Views: 537 ]

INDEX problem

Started on 24 September 2004 16:21
Last reply by vst on 24 September 2004 16:21
[ Posts: 0 ] [ Views: 696 ]

Re: [GENERAL] need ``row number``

Started on 24 September 2004 09:21
Last reply by tgl on 24 September 2004 16:20
[ Posts: 1 ] [ Views: 539 ]

need "row number"

Started on 23 September 2004 22:24
Last reply by Karsten.Hilbert on 23 September 2004 22:24
[ Posts: 0 ] [ Views: 733 ]

raise is not working

Started on 21 September 2004 18:44
Last reply by tgl on 23 September 2004 19:11
[ Posts: 6 ] [ Views: 1037 ]

plpgsql syntax

Started on 23 September 2004 17:32
Last reply by tgl on 23 September 2004 18:19
[ Posts: 2 ] [ Views: 802 ]

LIKE operator and string comparison

Started on 23 September 2004 00:54
Last reply by tgl on 23 September 2004 01:20
[ Posts: 3 ] [ Views: 2766 ]

Difference in DATEs

Started on 21 September 2004 09:38
Last reply by postgresql3 on 21 September 2004 17:53
[ Posts: 2 ] [ Views: 627 ]

Help with function

Started on 20 September 2004 22:36
Last reply by sszabo on 21 September 2004 17:25
[ Posts: 3 ] [ Views: 1265 ]

degradation in performance

Started on 21 September 2004 13:27
Last reply by lists on 21 September 2004 14:41
[ Posts: 3 ] [ Views: 642 ]

PL/pgSQL multidimension (matrix) array in function

Started on 16 September 2004 19:10
Last reply by mail on 21 September 2004 06:44
[ Posts: 1 ] [ Views: 8293 ]

CREATE TABLE AS SELECT....

Started on 16 September 2004 22:57
Last reply by ahammond on 20 September 2004 23:56
[ Posts: 1 ] [ Views: 1161 ]

How to check postgres running or not ?

Started on 17 September 2004 07:18
Last reply by Josh on 20 September 2004 18:30
[ Posts: 23 ] [ Views: 831 ]

Implicit Transactions

Started on 17 September 2004 16:44
Last reply by pgman on 20 September 2004 14:34
[ Posts: 1 ] [ Views: 663 ]

Sequence of SQL command execution involving triggers and stored procedures.

Started on 18 September 2004 06:54
Last reply by tgl on 18 September 2004 18:39
[ Posts: 1 ] [ Views: 727 ]

1-byte integers

Started on 17 September 2004 23:40
Last reply by gsstark on 18 September 2004 17:39
[ Posts: 1 ] [ Views: 671 ]

implementing an out-of-transaction trigger

Started on 15 September 2004 05:03
Last reply by Iain on 16 September 2004 07:15
[ Posts: 4 ] [ Views: 1263 ]

Preserving column order when recreating table.

Started on 15 September 2004 14:24
Last reply by ajs on 15 September 2004 17:36
[ Posts: 5 ] [ Views: 602 ]

sleep function

Started on 10 August 2004 16:05
Last reply by sanjjay on 15 September 2004 11:22
[ Posts: 5 ] [ Views: 5055 ]

explain analyze results are different for each iteration

Started on 15 September 2004 03:21
Last reply by sszabo on 15 September 2004 04:07
[ Posts: 2 ] [ Views: 656 ]

Difficulties to use a Set Returning Function on a join

Started on 14 September 2004 00:03
Last reply by al_nunes on 14 September 2004 00:03
[ Posts: 0 ] [ Views: 783 ]

CREATE RULE ignored, what did I do wrong

Started on 10 September 2004 23:36
Last reply by Andrew on 13 September 2004 20:13
[ Posts: 2 ] [ Views: 546 ]

Interpolation and extrapolation in SQL

Started on 13 September 2004 17:03
Last reply by tgl on 13 September 2004 17:16
[ Posts: 1 ] [ Views: 643 ]

what is maximum size of "text" datatype in postgres?

Started on 13 September 2004 10:35
Last reply by Christopher Browne on 13 September 2004 11:31
[ Posts: 1 ] [ Views: 639 ]