Home > Archive > PostgreSQL SQL > March 2006










Posts(1)March 31, 2006, 9:32 amUpdate or No update in a single sql/ improvement neede
Posts(5)March 30, 2006, 7:32 amUgly group by problem
Posts(3)March 30, 2006, 3:26 amFlight numbers data
Posts(1)March 30, 2006, 3:26 am$30,000 INCOME EVERY DAY GUARANTEED FOR ONE YEAR
Posts(2)March 29, 2006, 8:27 pmresults being col wise rather than row wise
Posts(1)March 29, 2006, 11:30 amGetting more information about errorcodes such as when these error1
Posts(1)March 29, 2006, 3:30 amAlternate of running a count(*) for paging
Posts(5)March 28, 2006, 8:28 pmBitfields always atomic? Other way to store attributes?
Posts(4)March 28, 2006, 1:31 pmUpdate question
Posts(4)March 28, 2006, 7:30 amcursor and for update
Posts(1)March 28, 2006, 3:29 amProposed dbmirror change
Posts(10)March 28, 2006, 3:29 amPermission to Select
Posts(6)March 27, 2006, 8:28 pmunique names in variables and columns in plsql functions
Posts(1)March 27, 2006, 1:36 pmpsqlODBC driver -- too many tables shown
Posts(1)March 27, 2006, 11:33 amALTER COLUMN from date to timestamp without time zone
Posts(7)March 27, 2006, 11:33 amProblem using set-returning functions
Posts(3)March 27, 2006, 9:38 amtable join
Posts(6)March 27, 2006, 9:38 amExpressing a result set as an array (and vice versa)?
Posts(2)March 27, 2006, 9:38 ampgsql2shp - Could not create dbf file
Posts(1)March 27, 2006, 9:38 amRe: [postgis-users] Problem using set-returning functions
Posts(8)March 27, 2006, 9:38 ampgsql aggregate: conditional max
Posts(9)March 27, 2006, 9:38 amQuestion about One to Many relationships
Posts(7)March 27, 2006, 9:38 amFind min and max values across two columns?
Posts(4)March 27, 2006, 9:38 amSQL Query Newbie Help
Posts(11)March 27, 2006, 7:40 amfunctions in WHERE clause
Posts(1)March 27, 2006, 7:40 amRe: [postgis-users] Problem using set-returning functions
Posts(3)March 25, 2006, 7:44 amIndex on nullable column
Posts(3)March 25, 2006, 7:44 amregarding join
Posts(6)March 24, 2006, 8:26 pmCustom type
Posts(2)March 24, 2006, 8:26 pmRe: generate_series to return row that doesn't exist in
Posts(1)March 24, 2006, 8:26 pmgenerate_series to return row that doesn't exist in table...
Posts(5)March 23, 2006, 1:33 pmOUT parameter
Posts(3)March 23, 2006, 7:45 amFunction Parameters in GROUP BY clause cause errors
Posts(12)March 22, 2006, 8:35 pmHow to optimize this query?
Posts(5)March 22, 2006, 9:31 amCOPY tablename FROM and null values
Posts(5)March 22, 2006, 9:31 amUsing a parameter in Interval
Posts(3)March 22, 2006, 3:28 amRe: Power cut and performance problem
Posts(7)March 22, 2006, 3:28 amReferential integrity broken (8.0.3), sub-select help
Posts(2)March 22, 2006, 3:28 amRe: Power cut and performance problem
Posts(2)March 21, 2006, 1:32 pmplpqsql and RETURN NEXT requires a LOOP?
Posts(2)March 21, 2006, 7:28 amJob queue, how would you implement this?
Posts(3)March 21, 2006, 3:33 amUpdate counter when row SELECT'd ... ?
Posts(1)March 21, 2006, 3:33 amUnable to connect To Database...
Posts(2)March 21, 2006, 3:33 amRe: Power cut and performance problem
Posts(1)March 21, 2006, 3:33 amRe: Power cut and performance problem
Posts(14)March 21, 2006, 3:33 amupdate before drop causes OID problems in transaction?
Posts(6)March 21, 2006, 3:32 amPostgreSQL Handling of Special Characters
Posts(2)March 21, 2006, 3:32 amLead and tail quotes with \pset fieldsep
Posts(3)March 19, 2006, 11:09 amHow to call table returning function with other table
Posts(2)March 19, 2006, 11:09 amrowcount for all tables
Posts(3)March 19, 2006, 11:09 amschema inspection
Posts(1)March 19, 2006, 11:09 amR: Re: R: Re: R: R: Re: schema inspection
Posts(1)March 19, 2006, 11:09 amR: Re: R: R: Re: schema inspection
Posts(14)March 19, 2006, 11:09 amconnectby documentation
Posts(5)March 19, 2006, 11:09 amgroup by function, make SQL cleaner?
Posts(1)March 19, 2006, 11:09 amhow to get current recursion level in recursive trigger?
Posts(4)March 17, 2006, 8:33 pmRe: in PlPgSQL function, how to use variable in a "select ...
Posts(1)March 17, 2006, 1:24 pmin PlPgSQL function, how to use variable in a "select ... into ..
Posts(3)March 17, 2006, 11:24 amdump with lo
Posts(1)March 17, 2006, 9:24 amChecking if date is inside date range
Posts(1)March 17, 2006, 7:24 amRe: Checking if date is inside date range
Posts(2)March 17, 2006, 3:27 amR: R: Re: schema inspection
Posts(1)March 17, 2006, 3:27 amRe: R: Re: R: R: Re: schema inspection
Posts(7)March 17, 2006, 3:27 amAbout how to use "exception when ??? then "
Posts(1)March 17, 2006, 3:27 am$25,000.00 WEEKLY INCOME.MAGAZINE FRANCHISE.WORK AT HOME
Posts(2)March 16, 2006, 8:24 pmexecuting external command
Posts(3)March 16, 2006, 11:25 amhelp with function
Posts(1)March 15, 2006, 1:16 pm!! DOWNLOAD THE MOST POPULAR 2006's CRACKED SOFTWARE(CAD/CAE/CAM/EDA/PCB/GIS/FEA/CNC/
Posts(4)March 15, 2006, 3:24 amCopying a row within table
Posts(2)March 14, 2006, 8:24 pmSavepoint/Rollback in functions
Posts(2)March 14, 2006, 8:24 pmhow to get the size of array?
Posts(1)March 14, 2006, 3:24 amRe: Permission to Select -- I am wrong
Posts(1)March 14, 2006, 3:24 amunsubscribe
Posts(1)March 14, 2006, 3:24 amunsubscribe
Posts(1)March 14, 2006, 3:24 amunsubscribe
Posts(1)March 13, 2006, 8:24 pmRe: [GENERAL] Update value to "the first character is capital
Posts(1)March 13, 2006, 8:24 pmRe: [GENERAL] Update value to "the first character is capital and
Posts(2)March 13, 2006, 8:24 pmUpdate value to "the first character is capital and the rest is small"
Posts(2)March 13, 2006, 1:24 pmConstraint Error effect on PostgreSQL
Posts(3)March 13, 2006, 11:24 amremoving "not null" modifier
Posts(4)March 13, 2006, 9:24 amSet generating functions and subqueries
Posts(1)March 13, 2006, 9:24 amRe: Ask a PostgreSql question (about select )
Posts(5)March 13, 2006, 7:25 amQuestion re: relational technique
Posts(1)March 13, 2006, 3:23 amRe: Ask a PostgreSql question (about select )
Posts(5)March 11, 2006, 11:23 amMerging rows into one result?
Posts(3)March 11, 2006, 7:23 aminput from a external text file......!
Posts(6)March 11, 2006, 7:23 amHow can I selet rows which have 2 columns values cross equal?
Posts(3)March 11, 2006, 3:23 amLocking row
Posts(2)March 11, 2006, 3:23 amREAD COMMITTE without START TRANSACTION?
Posts(1)March 10, 2006, 8:24 pmAdvice on setting up a grid like view for spreadsheet users
Posts(1)March 10, 2006, 7:25 amRe: dbLink Query
Posts(1)March 10, 2006, 7:25 amRe:
Posts(3)March 10, 2006, 7:25 ampg reserved words
Posts(1)March 10, 2006, 3:24 amBECOME A DOT.COM MILLIONAIRE WITH ONLY $5.99Cents or $1K.
Posts(1)March 9, 2006, 8:24 pmBECOME A DOT.COM MILLIONAIRE WITH ONLY $5.99Cents or $1K.
Posts(7)March 9, 2006, 11:24 amProblems with disabling triggers in Postgres 7.3.9
Posts(1)March 9, 2006, 9:24 amRe:
Posts(1)March 9, 2006, 9:24 amRe:
Posts(1)March 9, 2006, 9:24 amRe:
Posts(1)March 9, 2006, 9:24 am(NONE)
Posts(5)March 9, 2006, 7:26 amIs there any way to stop triggers from cycling?
Posts(1)March 9, 2006, 3:24 amSQL Query Help using sum
Posts(5)March 8, 2006, 8:24 pmRe: [HACKERS] Interval subtracting
Posts(1)March 8, 2006, 11:24 amErrors ignored on restore
Posts(1)March 8, 2006, 11:24 amRe: [GENERAL] Errors ignored on restore
Posts(1)March 7, 2006, 3:24 amWe Pay 50%--100% Returns Monthly For 1 yearr on investment. You need to know this!
Posts(4)March 7, 2006, 3:24 amRe: [GENERAL] problem with overloading the "coalesce" function
Posts(1)March 6, 2006, 7:18 pmRe: [GENERAL] Syntax error in Execute statement
Posts(6)March 6, 2006, 7:18 pmHelp with "missing FROM clause" needed
Posts(1)March 6, 2006, 7:18 pmSyntax error in Execute statement
Posts(1)March 6, 2006, 7:24 amproblem with overloading the "coalesce" function
Posts(1)March 5, 2006, 8:39 pmVisual and PostgreSQL
Posts(1)March 5, 2006, 8:39 pmHelp with distinctly non-intuitive rule behaviour
Posts(7)March 5, 2006, 8:39 pmCheck/unique constraint question
Posts(1)March 5, 2006, 8:39 pmunsubscribe
Posts(3)March 5, 2006, 8:39 pmGetting yyyy-mm-dd 00:00:00 in an arbitrary time zone
Posts(2)March 5, 2006, 8:39 pmSequential scan where Index scan expected.
Posts(2)March 5, 2006, 8:39 pmpg_dump and diffrent sizes
Posts(7)March 5, 2006, 8:39 pmSequential scan where Index scan expected (update)
Posts(4)March 5, 2006, 8:39 pmhow to make infinite intervals?
Posts(8)March 5, 2006, 8:39 pmHelp with trigger that updates a row prior to a potentially aborted deletion?
Posts(6)March 5, 2006, 8:39 pmnewbie question
Posts(4)March 5, 2006, 8:39 pmWhy do I get these results?????
Posts(3)March 5, 2006, 8:39 pmHow to check date-interval constraints
Posts(1)March 5, 2006, 8:39 pmRe: Why can't I use daylight savings time aware time zones with the AT TIME ZONE clause?
Posts(2)March 5, 2006, 8:39 pmQuestion about Sql SELECT and optimizer
Posts(10)March 5, 2006, 8:39 pmChange date format through an environmental variable?
Posts(2)March 5, 2006, 8:39 pmWithout OIDs
Posts(1)March 5, 2006, 8:39 pmFW: sql copy does not work
Posts(3)March 5, 2006, 8:39 pmProblem with query on history table
Posts(7)March 5, 2006, 8:39 pmReplication - state of the art?
Posts(5)March 5, 2006, 8:39 pmregarding grant option
Posts(1)March 5, 2006, 8:38 pmRe: [HACKERS] Interval subtracting
Posts(1)March 5, 2006, 8:38 pmRe: [HACKERS] Interval subtracting
Posts(1)March 5, 2006, 8:38 pmRe: [HACKERS] Interval subtracting
Posts(4)March 5, 2006, 8:38 pmgrant select,... over schema
Posts(1)March 5, 2006, 8:38 pmRe: Help with trigger that updates a row prior to a potentially
Posts(2)March 5, 2006, 8:38 pmRe: Index to support LIKE '%suffix' queries
Posts(1)March 5, 2006, 8:38 pmHow to get the count of matching colums for each row in one table with all the rows of another tabl
Posts(2)March 5, 2006, 8:38 pmhow to add primary key to existing table with multiple primary keys
Posts(8)March 5, 2006, 8:38 pmSlow update SQL
Posts(1)March 5, 2006, 8:38 pmEARN $3,000.00 A DAY. OPEN AN INCOME-DAILY ACCOUNT WITH US
Posts(1)March 5, 2006, 8:38 pmRe: how to add primary key to existing table with multiple
Posts(3)March 5, 2006, 8:38 pmORDER BY with LTREE


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

Copyright 2008 droptable.com