comp.databases.postgresql.sql

sql problem

Started on 05 November 2004 15:34
Last reply by achill on 05 November 2004 17:50
[ Posts: 1 ] [ Views: 758 ]

Delayed result from another connection

Started on 04 November 2004 18:19
Last reply by tgl on 05 November 2004 16:53
[ Posts: 3 ] [ Views: 667 ]

oracle v$session equivalent in postgresql

Started on 05 November 2004 16:27
Last reply by stuff on 05 November 2004 16:27
[ Posts: 0 ] [ Views: 775 ]

Help in stored procedure

Started on 05 November 2004 15:35
Last reply by tfo on 05 November 2004 16:13
[ Posts: 1 ] [ Views: 957 ]

Oracle to Postgres

Started on 05 November 2004 16:12
Last reply by faivrem on 05 November 2004 16:12
[ Posts: 0 ] [ Views: 791 ]

Group by and aggregates

Started on 04 November 2004 17:54
Last reply by Mich on 05 November 2004 15:51
[ Posts: 5 ] [ Views: 652 ]

CREATE TRIGGER ... FOR EACH STATEMENT

Started on 04 November 2004 23:16
Last reply by Mischa Sandberg on 05 November 2004 04:27
[ Posts: 1 ] [ Views: 899 ]

CREATE TYPE

Started on 03 November 2004 16:56
Last reply by Sad on 04 November 2004 07:30
[ Posts: 2 ] [ Views: 670 ]

Re: vacuum analyze slows sql query

Started on 03 November 2004 20:20
Last reply by gsstark on 03 November 2004 20:20
[ Posts: 0 ] [ Views: 618 ]

Re: vacuum analyze slows sql query

Started on 03 November 2004 19:31
Last reply by ajs on 03 November 2004 19:45
[ Posts: 1 ] [ Views: 593 ]

trigger status

Started on 03 November 2004 15:57
Last reply by Mike on 03 November 2004 16:33
[ Posts: 1 ] [ Views: 656 ]

Re: vacuum analyze slows sql query

Started on 03 November 2004 14:31
Last reply by Jim on 03 November 2004 14:31
[ Posts: 0 ] [ Views: 650 ]

Re: vacuum analyze slows sql query

Started on 03 November 2004 13:01
Last reply by ajs on 03 November 2004 13:01
[ Posts: 0 ] [ Views: 558 ]

'show databases' in psql way?

Started on 01 November 2004 13:13
Last reply by Greg on 03 November 2004 04:46
[ Posts: 8 ] [ Views: 22835 ]

Insert/Update Perl Function involving two tables needing to by 'in

Started on 03 November 2004 04:26
Last reply by fmiddleton on 03 November 2004 04:26
[ Posts: 0 ] [ Views: 685 ]

JOIN not being calculated correctly

Started on 29 Oktober 2004 00:16
Last reply by ahammond on 02 November 2004 19:46
[ Posts: 1 ] [ Views: 640 ]

Update instead rules on Views

Started on 02 November 2004 13:05
Last reply by schabios on 02 November 2004 16:42
[ Posts: 2 ] [ Views: 819 ]

Join Table

Started on 01 November 2004 17:34
Last reply by Mike on 02 November 2004 05:22
[ Posts: 6 ] [ Views: 1135 ]

paertially restoring a DB

Started on 29 Oktober 2004 16:04
Last reply by Iain on 01 November 2004 06:51
[ Posts: 1 ] [ Views: 651 ]

Error Trapping in Rules Triggers Functions

Started on 31 Oktober 2004 22:57
Last reply by aza_rc on 31 Oktober 2004 22:57
[ Posts: 0 ] [ Views: 632 ]

Re: Foreign Key Non-Null Problem in 8.0

Started on 31 Oktober 2004 07:22
Last reply by sszabo on 31 Oktober 2004 07:22
[ Posts: 0 ] [ Views: 526 ]

ORDER BY and NULLs

Started on 19 September 2004 16:57
Last reply by Murphy Pope on 31 Oktober 2004 02:00
[ Posts: 15 ] [ Views: 1107 ]

How do you compare (NULL) and (non-NULL)?

Started on 26 Oktober 2004 22:23
Last reply by Bruno on 29 Oktober 2004 19:57
[ Posts: 5 ] [ Views: 694 ]

Re: extra info - curious delay on view/where

Started on 28 Oktober 2004 16:53
Last reply by schabios on 29 Oktober 2004 19:46
[ Posts: 1 ] [ Views: 556 ]

Re: Functions return a select in a table, which data type I

Started on 29 Oktober 2004 11:08
Last reply by twanger on 29 Oktober 2004 11:08
[ Posts: 0 ] [ Views: 485 ]

Select Instead on a table

Started on 28 Oktober 2004 12:03
Last reply by schabios on 28 Oktober 2004 18:58
[ Posts: 2 ] [ Views: 630 ]

curious delay on view/where

Started on 28 Oktober 2004 12:16
Last reply by gary.stainburn on 28 Oktober 2004 17:01
[ Posts: 3 ] [ Views: 607 ]

How to re-sort a sorted query?

Started on 26 Oktober 2004 21:23
Last reply by yudie on 27 Oktober 2004 17:30
[ Posts: 5 ] [ Views: 545 ]

RULE and default nextval() column

Started on 27 Oktober 2004 15:19
Last reply by sszabo on 27 Oktober 2004 16:11
[ Posts: 1 ] [ Views: 601 ]

How to recognize trigger-inserted rows?

Started on 26 Oktober 2004 19:00
Last reply by jboes on 26 Oktober 2004 19:00
[ Posts: 0 ] [ Views: 543 ]

How to recognize trigger-inserted rows?

Started on 26 Oktober 2004 18:27
Last reply by Jeff Boes on 26 Oktober 2004 18:27
[ Posts: 0 ] [ Views: 514 ]

plpgsql: PERFORM vs. SELECT INTO (PERFORM not setting FOUND variable?)

Started on 25 Oktober 2004 21:44
Last reply by ebacon on 25 Oktober 2004 22:08
[ Posts: 2 ] [ Views: 982 ]

Re: "copy from" in "create function"

Started on 25 Oktober 2004 19:19
Last reply by JanWieck on 25 Oktober 2004 19:19
[ Posts: 0 ] [ Views: 499 ]

now() + integer, not rounded to whole day

Started on 22 Oktober 2004 14:04
Last reply by Bruno on 25 Oktober 2004 18:32
[ Posts: 2 ] [ Views: 576 ]

sql

Started on 25 Oktober 2004 10:13
Last reply by mrylander on 25 Oktober 2004 15:05
[ Posts: 4 ] [ Views: 896 ]

bibliographic schema

Started on 18 Oktober 2004 17:18
Last reply by cloos on 25 Oktober 2004 12:36
[ Posts: 4 ] [ Views: 652 ]

Cross tabulations

Started on 20 Oktober 2004 06:43
Last reply by middink on 25 Oktober 2004 10:49
[ Posts: 2 ] [ Views: 696 ]

Create interval using column value?

Started on 25 Oktober 2004 04:54
Last reply by llennhoff-postgres on 25 Oktober 2004 05:18
[ Posts: 3 ] [ Views: 616 ]

Re: Functions return a select in a table, which data type I

Started on 22 Oktober 2004 15:38
Last reply by twanger on 22 Oktober 2004 15:38
[ Posts: 0 ] [ Views: 475 ]

Finding duplicated values

Started on 21 Oktober 2004 20:58
Last reply by ch on 22 Oktober 2004 09:49
[ Posts: 4 ] [ Views: 873 ]