comp.databases.postgresql.sql

General Help on Query Writing, With Defined Schema

Started on 09 September 2008 17:44
Last reply by Jeff Nyman on 09 September 2008 17:44
[ Posts: 0 ] [ Views: 632 ]

convert character varying to int

Started on 19 April 2008 04:05
Last reply by RJ on 19 April 2008 04:05
[ Posts: 0 ] [ Views: 901 ]

Where is potential Afterburner when we need him?

Started on 12 Dezember 2007 05:15
Last reply by tester on 12 Dezember 2007 05:15
[ Posts: 0 ] [ Views: 859 ]

How can I get leading zeros in my PKey?

Started on 27 Oktober 2006 15:48
Last reply by Mark Drummond on 27 Oktober 2006 15:48
[ Posts: 0 ] [ Views: 1243 ]

select returning resuts in wrong order

Started on 21 August 2006 17:15
Last reply by gsexton on 21 August 2006 17:15
[ Posts: 0 ] [ Views: 1238 ]

Extracting the year

Started on 05 März 2006 08:59
Last reply by Bent Stigsen on 01 Juni 2006 01:33
[ Posts: 1 ] [ Views: 1610 ]

Timestamp not working

Started on 12 November 2005 16:47
Last reply by Stephen Prinster on 12 November 2005 18:52
[ Posts: 1 ] [ Views: 1430 ]

Generate/Manage a PostgresSQL database using Visio?

Started on 10 Oktober 2005 20:48
Last reply by Hannes Dorbath on 11 Oktober 2005 09:17
[ Posts: 1 ] [ Views: 1725 ]

[PG7.4] Using the data from temp table within a function

Started on 28 September 2005 15:49
Last reply by Brendon on 06 Oktober 2005 04:29
[ Posts: 1 ] [ Views: 4225 ]

Pick until enough

Started on 13 Juli 2005 21:00
Last reply by sun_tong on 13 Juli 2005 21:00
[ Posts: 0 ] [ Views: 1888 ]

User-defined tables

Started on 13 Juli 2005 08:10
Last reply by Mario Neudeck on 13 Juli 2005 08:10
[ Posts: 0 ] [ Views: 1970 ]

many-t-many and joins

Started on 09 Juli 2005 20:04
Last reply by Nick Hayworth on 09 Juli 2005 20:04
[ Posts: 0 ] [ Views: 1881 ]

Function that creates views

Started on 13 Juni 2005 11:03
Last reply by Ion Chalmers Freeman on 15 Juni 2005 23:44
[ Posts: 1 ] [ Views: 1967 ]

Calling a stored procedure from another stored procedure...

Started on 04 Mai 2005 10:24
Last reply by Christophe Geers on 09 Mai 2005 09:41
[ Posts: 1 ] [ Views: 8981 ]

Modifications made to Excel can be send to Database?

Started on 20 April 2005 13:07
Last reply by forum on 20 April 2005 13:45
[ Posts: 2 ] [ Views: 1465 ]

DateAdd function ?

Started on 19 April 2005 12:47
Last reply by zlatko.matic1 on 19 April 2005 12:47
[ Posts: 0 ] [ Views: 2074 ]

outer join in ms query

Started on 16 April 2005 19:20
Last reply by forum on 16 April 2005 19:20
[ Posts: 0 ] [ Views: 2675 ]

SQL group select question

Started on 14 April 2005 00:00
Last reply by Dave Roe on 14 April 2005 00:00
[ Posts: 0 ] [ Views: 3204 ]

SQL subquery (count distinct) - Any Ideas?

Started on 13 April 2005 20:07
Last reply by Matt Fulford on 13 April 2005 20:07
[ Posts: 0 ] [ Views: 4457 ]

World First Cancer Immune Booster

Started on 12 April 2005 07:25
Last reply by Inamori Izumi on 12 April 2005 07:25
[ Posts: 0 ] [ Views: 2169 ]

Select turnedOff/turnedOn time of interruptor in database

Started on 23 März 2005 14:51
Last reply by stephane.riff on 23 März 2005 14:51
[ Posts: 0 ] [ Views: 2110 ]

Select with substring or regular expression

Started on 17 März 2005 17:40
Last reply by ion on 22 März 2005 19:31
[ Posts: 2 ] [ Views: 6253 ]

Subquery Ordinals

Started on 22 März 2005 19:25
Last reply by ion on 22 März 2005 19:25
[ Posts: 0 ] [ Views: 2180 ]

How to build database to support user-specified attributes?

Started on 14 März 2005 18:51
Last reply by Kunle Odutola on 17 März 2005 17:06
[ Posts: 9 ] [ Views: 1684 ]

alter user privilege

Started on 14 März 2005 02:13
Last reply by forum on 14 März 2005 02:13
[ Posts: 0 ] [ Views: 2613 ]

Getting the Name of the Server

Started on 13 Februar 2005 01:34
Last reply by redblack on 13 Februar 2005 01:34
[ Posts: 0 ] [ Views: 2208 ]

Question about table design

Started on 11 Januar 2005 12:45
Last reply by Manlio Perillo on 20 Januar 2005 21:17
[ Posts: 6 ] [ Views: 2503 ]

Inheritance

Started on 13 Januar 2005 18:56
Last reply by Manlio Perillo on 13 Januar 2005 18:56
[ Posts: 0 ] [ Views: 2367 ]

sql problem

Started on 10 Januar 2005 21:05
Last reply by Erwin Moller on 12 Januar 2005 13:40
[ Posts: 1 ] [ Views: 2540 ]

convert strings in a file to integer

Started on 09 Januar 2005 18:51
Last reply by Erwin Moller on 12 Januar 2005 13:31
[ Posts: 1 ] [ Views: 3424 ]

Real Election Reform

Started on 08 Januar 2005 06:42
Last reply by D Flint on 08 Januar 2005 06:42
[ Posts: 0 ] [ Views: 2215 ]

rowtypes as arguments to functions

Started on 22 Dezember 2004 19:30
Last reply by Jose Fernandes on 22 Dezember 2004 19:30
[ Posts: 0 ] [ Views: 2653 ]

Oid Type

Started on 12 Dezember 2004 18:56
Last reply by Luca on 12 Dezember 2004 18:56
[ Posts: 0 ] [ Views: 2533 ]

The second RFD is in news.groups.

Started on 24 November 2004 03:43
Last reply by Mike Cox on 24 November 2004 03:43
[ Posts: 0 ] [ Views: 2396 ]

NULLS and string concatenation

Started on 19 November 2004 18:12
Last reply by ahammond on 23 November 2004 20:16
[ Posts: 8 ] [ Views: 5901 ]

Re: Image Insert Doubt

Started on 23 November 2004 19:39
Last reply by vishalonlist on 23 November 2004 19:39
[ Posts: 0 ] [ Views: 2304 ]

Image Insert Postgresql DB

Started on 23 November 2004 05:21
Last reply by Premsun on 23 November 2004 10:45
[ Posts: 7 ] [ Views: 18850 ]

Recursive SETOF function

Started on 22 November 2004 16:18
Last reply by lists on 23 November 2004 00:19
[ Posts: 6 ] [ Views: 7286 ]

Missing SELECT INTO ... DEFAULT VALUES in plpgsql for composite t

Started on 22 November 2004 17:43
Last reply by Vadim.Passynkov on 22 November 2004 17:43
[ Posts: 0 ] [ Views: 3568 ]

get sequence value of insert command

Started on 19 November 2004 09:41
Last reply by Vadim.Passynkov on 22 November 2004 15:58
[ Posts: 6 ] [ Views: 5581 ]