Home > Archive > PostgreSQL SQL > June 2005










Posts(1)June 30, 2005, 9:24 amUpdatable view
Posts(4)June 30, 2005, 7:25 amSQL Query question
Posts(15)June 30, 2005, 7:25 amORDER records based on parameters in IN clause
Posts(2)June 30, 2005, 3:23 amError saving image to PostgresSQL 8.x database
Posts(2)June 29, 2005, 8:24 pmForeign key pg_dump issue and serial column type
Posts(3)June 29, 2005, 9:24 amcross-table reference
Posts(1)June 29, 2005, 9:24 amInsert rule and default values for PK
Posts(10)June 28, 2005, 8:24 pmpeople who buy A, also buy C, D, E
Posts(5)June 28, 2005, 1:23 pmUnique primary index?
Posts(1)June 28, 2005, 7:24 amERROR: "TZ"/"tz" not supported
Posts(4)June 28, 2005, 3:24 amcustomising serial type
Posts(1)June 28, 2005, 3:24 amHelp with query, stuck :(
Posts(2)June 27, 2005, 8:24 pmpg_attribute.attlen -1 for varchar e pbchar fields
Posts(4)June 27, 2005, 8:24 pmSELECT * FROM foo OFFSET -1 LIMIT 1
Posts(5)June 27, 2005, 1:24 pmHow can I simply substatue a value in a query?
Posts(4)June 26, 2005, 8:23 pmmultiple PK with a non UNIQUE field
Posts(4)June 26, 2005, 1:23 pmassorted problems with intarray and other GiST contribs.
Posts(2)June 26, 2005, 3:23 amusing 'zoneinfo' to manipulate dates ...
Posts(5)June 25, 2005, 3:23 amGrouping Too Closely
Posts(1)June 24, 2005, 8:24 pmDefault index space?
Posts(2)June 24, 2005, 1:25 pmConverting TBL->View complaining about indexes
Posts(8)June 24, 2005, 9:23 amempty view, replace view, column type change?
Posts(2)June 23, 2005, 8:24 pmoptimizer, view, union
Posts(8)June 23, 2005, 9:24 amafter delete trigger behavior
Posts(1)June 22, 2005, 8:24 pmencoding question
Posts(8)June 22, 2005, 9:23 amAlias to a type
Posts(1)June 22, 2005, 3:24 amRe: scroll cursor bug or me?
Posts(1)June 21, 2005, 9:23 amSELECT INTO returning more than one row
Posts(1)June 21, 2005, 7:24 amSELECT INTO returning more than one row
Posts(2)June 20, 2005, 8:24 pmSQL repr of bytea val
Posts(2)June 20, 2005, 8:24 pmArray in plpgsql with composite type
Posts(3)June 20, 2005, 7:24 aminfo
Posts(2)June 20, 2005, 7:24 amFW: help with serial
Posts(11)June 20, 2005, 7:24 amUPDATEABLE VIEWS ... Examples?
Posts(1)June 20, 2005, 7:24 amRe: [despammed] info
Posts(2)June 20, 2005, 3:23 amaccessing database without a persistent connection
Posts(2)June 20, 2005, 3:23 amAYUDA CON LA INSTALACION DEL POSTGRESQL
Posts(7)June 19, 2005, 8:24 pmPutting an INDEX on a boolean field?
Posts(4)June 19, 2005, 11:23 amWHY transaction waits for another transaction?
Posts(2)June 19, 2005, 9:23 amLooking for info on 8.1 features, and some examples
Posts(2)June 19, 2005, 7:24 amDynamic PL/pgSQL
Posts(1)June 19, 2005, 7:24 amRe: Set Membership operator -- test group membership
Posts(4)June 19, 2005, 3:24 ampartial index on non default tablespace syntax
Posts(7)June 17, 2005, 1:25 pmSELECT with sum on groups ORDERING by the subtotals
Posts(1)June 17, 2005, 11:25 amRe: how can i UPDATE without dead rows
Posts(1)June 17, 2005, 7:26 amRe: [despammed] substr or char_length problem
Posts(2)June 17, 2005, 7:26 amsubstr or char_length problem
Posts(3)June 17, 2005, 3:26 amStill getting autoreplies from list member
Posts(15)June 16, 2005, 11:24 amSELECT very slow
Posts(2)June 16, 2005, 11:24 amcursor "<unnamed portal 1>" does not exist
Posts(2)June 16, 2005, 9:23 amfunny update, say update 1, updated 1 added 2nd.
Posts(5)June 16, 2005, 7:24 amFunction does not return, but gives error..
Posts(2)June 15, 2005, 8:25 pmFunction that creates views
Posts(5)June 15, 2005, 9:24 amupdate syntax
Posts(2)June 15, 2005, 9:24 amConverting varchar to bool
Posts(8)June 15, 2005, 3:24 amgetting details about integrity constraint violation
Posts(2)June 14, 2005, 9:24 amforeign key on pg_shadow
Posts(1)June 14, 2005, 3:24 amSpam Re: read it immediately
Posts(4)June 13, 2005, 8:24 pmAggregate Functions Template
Posts(4)June 13, 2005, 3:23 ampredicate locking
Posts(5)June 11, 2005, 3:26 amHow do write a query...
Posts(3)June 10, 2005, 8:24 pmStudents in classes sql puzzle
Posts(6)June 10, 2005, 7:24 amRe: [GENERAL] Permission denied for language pltclu
Posts(1)June 10, 2005, 7:24 amHow-to suggestions to views
Posts(7)June 10, 2005, 7:24 amRe: Permission denied for language pltclu
Posts(4)June 9, 2005, 3:23 amRe: [despammed] rejecting characters in a field
Posts(4)June 9, 2005, 3:23 amIndices and user defined operators
Posts(2)June 9, 2005, 3:23 amrejecting characters in a field
Posts(4)June 8, 2005, 8:24 pmRule
Posts(1)June 8, 2005, 8:24 pm[Fwd: RE: Re: Rule]
Posts(1)June 8, 2005, 8:24 pmMaximum no. of tables in query?
Posts(1)June 8, 2005, 1:24 pmRe: plpgsql dynamic record access
Posts(2)June 8, 2005, 11:23 amaccess to new/old in dynamic sql for audit table
Posts(2)June 8, 2005, 11:23 amCursor need it?
Posts(1)June 8, 2005, 7:24 amExperience with splitting a Table transparently
Posts(6)June 7, 2005, 8:24 pmto listadmin
Posts(3)June 7, 2005, 11:24 amrule or trigger?
Posts(1)June 7, 2005, 7:24 amCan we stop that?
Posts(4)June 7, 2005, 7:24 amSQL equivalent to nested loop
Posts(6)June 7, 2005, 3:24 amWhat is faster?
Posts(3)June 7, 2005, 3:24 ampreventing deletion of a row
Posts(2)June 7, 2005, 3:24 amlarge object support in PostGres 7.4
Posts(1)June 7, 2005, 3:24 amdatestyle syntax
Posts(2)June 6, 2005, 9:23 amhow to store more than 3 MB of character data in Postgres Varchar field
Posts(1)June 6, 2005, 7:24 amRe: how to store more than 3 MB of character data in Postgres
Posts(1)June 6, 2005, 7:24 amRe: how to store more than 3 MB of character data in Postgres
Posts(2)June 6, 2005, 7:24 amReturning a Cross Tab record set from a function
Posts(2)June 6, 2005, 3:24 amplpgsql and triggers
Posts(4)June 5, 2005, 8:24 pmMultiple SRF parameters from query
Posts(1)June 5, 2005, 8:24 pmUnique keys on views
Posts(4)June 5, 2005, 8:24 pmConvert int to hex
Posts(7)June 4, 2005, 8:23 pmRe: ARRAY() returning NULL instead of ARRAYresp. {}
Posts(1)June 4, 2005, 7:23 amTsearch2 headline usage
Posts(15)June 3, 2005, 11:24 am'true'::TEXT::BOOLEAN
Posts(3)June 3, 2005, 11:24 amusing a selected row as a function parameter
Posts(2)June 3, 2005, 9:24 amCASE WHEN foo IS NULL THEN DEFAULT ELSE foo END
Posts(1)June 3, 2005, 9:24 amRe: 'true'::TEXT::BOOLEAN doesn't work
Posts(3)June 2, 2005, 8:24 pmRe: index row size 2728 exceeds btree maximum, 27
Posts(4)June 2, 2005, 11:24 amRe: [GENERAL] index row size 2728 exceeds btree maximum, 27
Posts(1)June 2, 2005, 11:24 amSplitting a table for performance reasons
Posts(2)June 2, 2005, 7:24 amindex row size 2728 exceeds btree maximum, 2713
Posts(1)June 2, 2005, 7:24 amRe: [GENERAL] index row size 2728 exceeds btree maximum, 2713
Posts(2)June 1, 2005, 8:24 pmRelease feature
Posts(10)June 1, 2005, 1:23 pmSum() rows
Posts(1)June 1, 2005, 1:23 pmunsubscribe
Posts(4)June 1, 2005, 11:24 amView unique rowid


Also available: Server administration forum archive | Web Design forum archive | Software forum archive | Hardware reviews archive | Programming forum archive

Copyright 2008 droptable.com