PDA

View Full Version : pgsql Sql

Pages : 1 [2] 3 4 5 6 7 8 9 10 11 12 13 14
  1. operator class
  2. Subselects returning array and ANY...
  3. REFERENCES and INHERITS restrictions?
  4. how do I get table DDL from psql (not from pg_dump)
  5. duplicate key violates unique constraint
  6. Function returns error (view)
  7. Re: Deploying PostgreSQL on virtualized hardware
  8. Bounce test
  9. autovacuum not freeing up unused space on 8.3.0
  10. function to compare a string
  11. Delete with foreign keys
  12. SQL standards in Mysql
  13. postgresql function not accepting null values in select statement
  14. cross-schema view
  15. Data layer migration from MSSQL
  16. Re: Proposed archival read only trigger on rows - preventhistory modification
  17. undefined relations in pg_locks
  18. Escaping of RegEx?
  19. Re: Helper aggregate function
  20. Except without elimination of non-distinct rows
  21. Re: Except without elimination of non-distinct rows
  22. ignore NULL FKs
  23. Opposite of "not in"
  24. can a insert with a returning clause be subquery ?
  25. Helper aggregate function
  26. aggregate reverse
  27. Re: Problem with the to_timestamp function
  28. SQL tree duplication
  29. date format
  30. ALTER TABLE <mytable> DROP CONSTRAINT IF EXISTS <myconstraint> ?
  31. Re: improvements to query with hierarchical elements
  32. currval() within one statement
  33. TIMESTAMP comparison problem
  34. improvements to query with hierarchical elements
  35. Having elements of an int[]-array reference other tables
  36. transaction and triggers
  37. How to test/read a stored procedure that returns a boolean?
  38. obtaining the query string inside a trigger
  39. SQL dealing with subquery comparison
  40. Update PK Violation
  41. SQL dealing with subquery
  42. Is DATETIME an ANSI-SQL type?
  43. Re: UTF8 encoding and non-text data types
  44. Unescaping text or binary file
  45. table column names - search
  46. Re: UTF8 encoding and non-text data types
  47. UTF8 encoding and non-text data types
  48. Re: UTF8 encoding and non-text data types
  49. SQL question: Highest column value of unique column pairs
  50. SQL stored function inserting and returning data in a row.
  51. (possible) bug with constraint exclusion
  52. Re: JOIN a table twice for different values in the same query
  53. Re: trigger for TRUNCATE?
  54. Escape sequence for UTF-8 Character Literals?
  55. JOIN a table twice for different values in the same query
  56. Shorthand column labels (SELECT col1 foo, ...) vs (SELECT col1 ASfoo, ...)
  57. Support for SQL TOP clause?
  58. Re: How to keep at-most N rows per group? periodic DELETEs orconstraints or..?
  59. trigger for TRUNCATE?
  60. Re: How to keep at-most N rows per group? periodic DELETEs orconstraints or..?
  61. How to keep at-most N rows per group? periodic DELETEs or constraints or..?
  62. Get the max(value1, value2, value3) from a table
  63. reading WAL files in python
  64. Cheers for DISTINCT ON
  65. WAL archiving blowed.
  66. tsearch2: ts_headline performance problem
  67. Re: Argentinian timezone change at the last moment. How to change pgsql tz db?
  68. PG is in different timezone than the OS
  69. Using rules to implement backward-compatible schema changes
  70. M,I-5 Pers ecution Thr ee Years of MI5 P ersecution Fax es
  71. M`I 5`Pe rsecution . MI5 Wan t Me to Send Yo u the se Fa xes
  72. M I.5 Perse cution MI 5 Insi st tha t th ese Fax es mu st Continu e
  73. M I`5'Pers ecution , 22, 544 + 837 = 23,38 1
  74. Limit # of recs on inner join?
  75. M`I'5`Per secution ` Molestatio n durin g Tr avel
  76. M I`5,P ersecution M I5 a re A fraid to Adm it T heyre Behi nd the Persecution
  77. M`I'5`Persecu tion ` No Justic e f or the Vic tims of MI 5
  78. M-I'5.Persecuti on . MI 5 H ave Syst ematically Destroy ed My Life
  79. M'I.5,Perse cution Haras sment t hrough the Radio
  80. Re: temp table existence
  81. PL/pgsql: function passing argument to IN operator
  82. temp table existence
  83. sql query question ?
  84. how to use pgsql like mssql
  85. Re: how to use pgsql like mssql
  86. M I-5 Persec ution ' BB C Newscasters L ie & Deny T heyre Watchi ng Me
  87. need help
  88. Re: need help
  89. M I-5 Pe rsecution , MI5 Wa ste Taxpa yer Millio ns on Poi ntless Hate-Campaig n
  90. M'I.5 Perse cution , F our Ye ars of M I5 Per secution P osts on Intern et Newsgroup s
  91. Advice for generalizing trigger functions
  92. M`I'5-Persecut ion . C omparing t he M I5 P ersecution wi th G erman Final Solut ion
  93. slow query - only uses indices
  94. Different Query plans filtering between dates
  95. returning an array as a list fo single-column rows?
  96. Misnamed field in subquery does not cause error when field name exists in parent query
  97. Concatenation through SQL
  98. sql query - create replace function
  99. DBLink or setof record functions & type shortcuts
  100. trigger problem with an if statement
  101. Re: Describe Table
  102. System catalog future changes
  103. Insert into and Sequence
  104. Bad count of rows estimated for emerge join
  105. Describe Table
  106. passing a multiple join to a function?
  107. SELECT MAX returns wrong value
  108. odd error updating - varchar
  109. Re: Query design assistance - getting daily totals
  110. Trigger definition . . . puzzled
  111. Re: Trigger definition . . . puzzled
  112. Query Assistance
  113. Function result using execute
  114. Query design assistance - getting daily totals
  115. Re: case sensitivity for tables, columns, and constraint names
  116. Foreign Key for multi PK or design question
  117. Re: case sensitivity for tables, columns, and constraint names
  118. Re: case sensitivity for tables, columns, and constraint names
  119. Insert Rule, Multiple Insert, Update Problem
  120. Re: INSERT INTO relational tables
  121. SQL INSERT/TRIGGER Help
  122. join on three tables is slow
  123. Rule rewrite to possible union?
  124. INSERT INTO relational tables
  125. Rows of one table "mask" rows of another
  126. polymorphic functions and domains
  127. plpythonu and "hello concurrent world"
  128. execute system command from storage procedure
  129. Error OID
  130. marking tuples
  131. alias required by standard or PostgreSQL?
  132. Problem with query
  133. Calling functions from within pl/pgsql
  134. Using schema
  135. Crosstab limitation...
  136. (NONE)
  137. Re: statement-level trigger sample out there?
  138. statement-level trigger sample out there?
  139. obtaining column names from tables or views
  140. pg_clog (?) problem with VACUMM
  141. Strang behaviour SELECT ... LIMIT n FOR UPDATE
  142. NULLIF problem
  143. PG trouble with index-usage in sort
  144. materialize
  145. Aleatory exception
  146. SQL state: 22P02
  147. How to have a unique primary key on two tables
  148. update on join ?
  149. Bad Schema Design or Useful Trick?
  150. PL argument max size, and doubt
  151. Run Function With First Priority
  152. Loading 8.2 data into 8.1
  153. dynmic column names inside trigger?
  154. MI5 Persecution: Faxes Sent to Media1 (6308)
  155. MI5 Persecution: Faxes Sent to Media2 (8483)
  156. EXPLAIN ANALYZE inside functions
  157. Aggregate question (Sum)
  158. MI5 Persecution: Post Office 14/11/02 (25883)
  159. MI5 Persecution: Eclipse pub 20/12/02 (28058)
  160. MI5 Persecution: Barbican Library 6/2/2003 (30233)
  161. MI5 Persecution: Bernard Levin - The Times (32408)
  162. MI5 Persecution: Come back, Norma! (34583)
  163. MI5 Persecution: Victor Lewis-Smith (36758)
  164. MI5 Persecution: Introduction to Sent Faxes (1958)
  165. MI5 Persecution: Faxes Sent to Diplomatic/Legal (4133)
  166. MI5 Persecution: Ravenscourt Park 20/3/99 (6308)
  167. MI5 Persecution: Battersea Library 29/3/99 (8483)
  168. MI5 Persecution: Royal Festival Hall 15/4/99 (10658)
  169. MI5 Persecution: Balham Bus 8/7/99 (12833)
  170. MI5 Persecution: Clapham South 17/2/00 (15008)
  171. MI5 Persecution: Clapham Junction 6/5/00 (17183)
  172. MI5 Persecution: he's an idiot you know 3/11/00 (19358)
  173. MI5 Persecution: tinker tailor wanker thief 2/12/00 (21533)
  174. MI5 Persecution: Jon Holmes (4-5/Jan/2002) (23708)
  175. MI5 Persecution: BA984 LHR->TXL 13/6/98 (1958)
  176. MI5 Persecution: BHS Croydon 18/12/98 (4133)
  177. Erlang & PostgreSQL native driver
  178. Is there anything special about pg_dump's compression?
  179. trap for any exception
  180. postgres bogged down beyond tolerance
  181. ALL() question
  182. Originally created and last_mod by whom and when ?
  183. Problem with UNION-queries
  184. plpgsql language not aware of standard_conforming_strings ?
  185. show value of backslashes in string array argument
  186. MI5 Persecution: Leicester Square 9/2/98 (15000)
  187. Search for ternary-like operation in plpgsql that accepts a mix of types
  188. general question on optimizer
  189. MI5 Persecution: Neil Fox (Nov/1998) (1956)
  190. MI5 Persecution: Flying Eye (Mar/1999) (4130)
  191. MI5 Persecution: Johnny Boy (21/Aug/1998) (6304)
  192. MI5 Persecution: Johnny Boy (19/June/1999) (8478)
  193. MI5 Persecution: Brighton 24/9/98 (10652)
  194. MI5 Persecution: POSK 2/2/98 (12826)
  195. functions are returns columns
  196. Select in From clause
  197. quote_nullable alternative?
  198. design of tables for sparse data
  199. Bitemporal - problem with correalated subquery?
  200. Re: Partitioning and Foreign Keys
  201. Obtaining the primary key of the record just inserted
  202. Temporal databases
  203. EPOCH TIMESTAMP Conversion Problem
  204. Treating result of subselect as row
  205. Scrolling cursors in PL/PgSQL
  206. changing encoding of a postgres database
  207. Returning the total number of rows as a separate column when using limit
  208. Re: omitting redundant join predicate
  209. Returning the total number of rows as a separate column when using limit
  210. Backup Database
  211. puzzled by SELECT INTO
  212. Perfomance benefit using Min() against order by & limit 1?
  213. update from select
  214. Select into with dynamic criteria in a plpgsql function
  215. Removing whitespace using regexp_replace
  216. Returning an array from a subquery
  217. hidden versioning system
  218. JOINing based on whether an IP address is contained within a CIDR range?
  219. Re: ERROR: failed to re-find parent key in "pk_ep07"
  220. (repost) Help understanding expressions in order by clause
  221. ERROR: failed to re-find parent key in "pk_ep07"
  222. get only rows for latest version of contents
  223. Re: get only rows for latest version of contents
  224. Quick question re foreign keys.
  225. request for help with COPY syntax
  226. backup database tablespace with rsync?
  227. two queryes in a single tablescan
  228. when inserting to table, text type parameter become NULL (after big assignment to this parameter)
  229. what's wrong with my date comparison?
  230. Having difficulty writing a "best-fit" query..
  231. Inconsistent sql result
  232. How to escape a memo field as a binary value in postgresql
  233. OT: array_accum equivalent in Oracle
  234. Accessing field of OLD in trigger
  235. Re: Refactored queries needing validation of syntactic equivalence
  236. seg data type
  237. Computed table name in function
  238. array handling on 8.0.3
  239. Get different sums from the same table in one query
  240. pg_dump question
  241. Re: [ADMIN] Postgres Array Traversing Problem
  242. Re: Rule Error
  243. What SQL is running against my DB?
  244. Rule Error
  245. UNIQUEness and time interval
  246. Why does the sequence skip a number with generate_series?
  247. field separator problem
  248. Need help with CASE statement in Function
  249. Finding broken regex'es
  250. Populate unique column with default value