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: 384 ]

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: 629 ]

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: 653 ]

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: 986 ]

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: 997 ]

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: 1272 ]

Timestamp not working

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

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: 1501 ]

[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: 3658 ]

Pick until enough

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

User-defined tables

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

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: 1603 ]

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: 1696 ]

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: 8222 ]

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: 1197 ]

DateAdd function ?

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

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: 2395 ]

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: 2839 ]

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: 4046 ]

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: 1905 ]

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: 1848 ]

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: 5309 ]

Subquery Ordinals

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

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: 1453 ]

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: 2236 ]

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: 1936 ]

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: 2249 ]

Inheritance

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

sql problem

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

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: 3163 ]

Real Election Reform

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

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: 2260 ]

Oid Type

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

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: 2111 ]

NULLS and string concatenation

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

Re: Image Insert Doubt

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

Image Insert Postgresql DB

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

Recursive SETOF function

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

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: 3082 ]

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: 4959 ]