comp.databases.postgresql.sql

Trouble with explicit joins

Started on 22 Oktober 2004 00:44
Last reply by Dmitry on 22 Oktober 2004 01:36
[ Posts: 2 ] [ Views: 703 ]

Reuse previously calculated column in sql query?

Started on 20 Oktober 2004 14:50
Last reply by achill on 21 Oktober 2004 14:35
[ Posts: 4 ] [ Views: 610 ]

time of constraint checking

Started on 20 Oktober 2004 17:58
Last reply by sszabo on 20 Oktober 2004 18:56
[ Posts: 2 ] [ Views: 693 ]

Re: the problem of createlang!

Started on 20 Oktober 2004 16:57
Last reply by laser on 20 Oktober 2004 16:57
[ Posts: 0 ] [ Views: 643 ]

SQL update function faililed in Webmin Interface

Started on 20 Oktober 2004 09:03
Last reply by dev on 20 Oktober 2004 09:37
[ Posts: 1 ] [ Views: 595 ]

Re: help with to_date and to_char

Started on 19 Oktober 2004 23:27
Last reply by tfo on 20 Oktober 2004 05:29
[ Posts: 5 ] [ Views: 944 ]

Re: need query advice

Started on 20 Oktober 2004 02:14
Last reply by lists on 20 Oktober 2004 02:14
[ Posts: 0 ] [ Views: 828 ]

Re: the problem of createlang!

Started on 19 Oktober 2004 23:31
Last reply by tgl on 19 Oktober 2004 23:31
[ Posts: 0 ] [ Views: 520 ]

Aggregate Function with Argument

Started on 18 Oktober 2004 17:24
Last reply by gibsonm on 19 Oktober 2004 16:50
[ Posts: 2 ] [ Views: 850 ]

problems using phpPgAmin

Started on 18 Oktober 2004 18:28
Last reply by gibsonm on 19 Oktober 2004 13:47
[ Posts: 3 ] [ Views: 945 ]

Ordering a record returned from a stored procedure

Started on 18 Oktober 2004 17:59
Last reply by dev on 19 Oktober 2004 10:21
[ Posts: 4 ] [ Views: 679 ]

Database backup

Started on 17 Oktober 2004 05:19
Last reply by maps.on on 18 Oktober 2004 18:39
[ Posts: 2 ] [ Views: 1289 ]

Installation woes

Started on 18 Oktober 2004 15:56
Last reply by mha on 18 Oktober 2004 17:12
[ Posts: 1 ] [ Views: 1048 ]

Inserting into table only if the row does not already exist.

Started on 15 Oktober 2004 06:18
Last reply by Benny on 17 Oktober 2004 08:04
[ Posts: 6 ] [ Views: 1405 ]

libpq-fe: PQgetvalue() ?

Started on 14 Oktober 2004 14:34
Last reply by tgl on 15 Oktober 2004 16:21
[ Posts: 3 ] [ Views: 3234 ]

Plperlu function & backticks return value -> truncated?

Started on 13 Oktober 2004 17:07
Last reply by philippe.lang on 13 Oktober 2004 17:54
[ Posts: 3 ] [ Views: 1431 ]

Export tab delimited from mysql to postgres.

Started on 11 Oktober 2004 00:59
Last reply by Theo.Galanakis on 13 Oktober 2004 01:56
[ Posts: 8 ] [ Views: 1840 ]

Information about the command SQL " create synonym".

Started on 12 Oktober 2004 15:04
Last reply by peter_e on 12 Oktober 2004 19:37
[ Posts: 1 ] [ Views: 712 ]

SQL confusion

Started on 09 Oktober 2004 22:39
Last reply by tfo on 12 Oktober 2004 19:01
[ Posts: 3 ] [ Views: 668 ]

JDBC +CIDR

Started on 12 Oktober 2004 17:54
Last reply by jrobette on 12 Oktober 2004 17:54
[ Posts: 0 ] [ Views: 706 ]

PL/pgSQL, RETURN NEXT, ORDER

Started on 12 Oktober 2004 15:24
Last reply by twanger on 12 Oktober 2004 15:41
[ Posts: 1 ] [ Views: 697 ]

How do FKs work?

Started on 09 Oktober 2004 20:08
Last reply by vygen on 11 Oktober 2004 13:03
[ Posts: 6 ] [ Views: 608 ]

table update using result from join

Started on 11 Oktober 2004 11:49
Last reply by gary.stainburn on 11 Oktober 2004 11:49
[ Posts: 0 ] [ Views: 679 ]

SQL doubt - Date Add

Started on 10 Oktober 2004 16:19
Last reply by dev on 11 Oktober 2004 11:21
[ Posts: 3 ] [ Views: 2375 ]

SELECT with Function

Started on 29 September 2004 15:51
Last reply by postgres on 09 Oktober 2004 17:11
[ Posts: 2 ] [ Views: 905 ]

Impact of foreign keys on a simple count(*) ?

Started on 09 Oktober 2004 05:37
Last reply by Benny on 09 Oktober 2004 06:13
[ Posts: 2 ] [ Views: 608 ]

help on a query

Started on 08 Oktober 2004 05:03
Last reply by gsstark on 09 Oktober 2004 05:17
[ Posts: 7 ] [ Views: 626 ]

Record Count

Started on 08 Oktober 2004 19:51
Last reply by Mike on 08 Oktober 2004 21:32
[ Posts: 1 ] [ Views: 783 ]

Query from different Database

Started on 07 Oktober 2004 10:52
Last reply by systemguards on 07 Oktober 2004 22:58
[ Posts: 2 ] [ Views: 704 ]

SQL search question

Started on 07 Oktober 2004 15:22
Last reply by dDave on 07 Oktober 2004 15:22
[ Posts: 0 ] [ Views: 623 ]

[ANN] Venus (DBA and Productivity Tool for every DBA, system analyst, ...)

Started on 07 Oktober 2004 06:41
Last reply by binhph on 07 Oktober 2004 06:41
[ Posts: 0 ] [ Views: 478 ]

Table locks

Started on 06 Oktober 2004 22:36
Last reply by systemguards on 06 Oktober 2004 22:36
[ Posts: 0 ] [ Views: 686 ]

How to query a set of tables with identical structure?

Started on 06 Oktober 2004 21:49
Last reply by bwvb on 06 Oktober 2004 21:49
[ Posts: 0 ] [ Views: 515 ]

Database Backup

Started on 06 Oktober 2004 04:39
Last reply by sklassen on 06 Oktober 2004 17:19
[ Posts: 1 ] [ Views: 610 ]

Howto turn an integer into an interval?

Started on 05 Oktober 2004 14:07
Last reply by erik.wasser on 06 Oktober 2004 10:13
[ Posts: 4 ] [ Views: 750 ]

Regex

Started on 06 Oktober 2004 02:52
Last reply by Theo.Galanakis on 06 Oktober 2004 07:44
[ Posts: 2 ] [ Views: 891 ]

Stored Procedures returning a RECORD

Started on 05 Oktober 2004 19:52
Last reply by jeff_eckermann on 05 Oktober 2004 22:41
[ Posts: 1 ] [ Views: 1174 ]

Using timestamp in function

Started on 05 Oktober 2004 17:37
Last reply by Mike on 05 Oktober 2004 18:19
[ Posts: 2 ] [ Views: 713 ]

Stuffing six separate columns into a single array?

Started on 05 Oktober 2004 05:56
Last reply by Benny on 05 Oktober 2004 15:26
[ Posts: 2 ] [ Views: 497 ]

Difference between IN and JOIN

Started on 04 Oktober 2004 10:39
Last reply by twanger on 04 Oktober 2004 16:23
[ Posts: 2 ] [ Views: 574 ]