PDA

View Full Version : pgsql Sql

Pages : [1] 2 3 4 5 6 7 8 9 10 11 12 13 14
  1. xpath_table
  2. Query tuning
  3. Add a ROWCOUNT to the output of a select.
  4. Problem with transaction isolation level
  5. Auto-formatting timestamps?
  6. merge timestamps to intervals
  7. Difference in columns
  8. merge timestamps to intervals
  9. execute plpgsl like "normal" sql
  10. Effective DB Design Question
  11. Index to enforce non-overlapping ranges?
  12. Joining with result of a plpgsql function
  13. Insert with pl/pgsql trigger
  14. how to check if a point is contained in a polygon ?
  15. dbmirror - migration to 8.3 from 7.4
  16. Database normalization
  17. Working with dates before 4713 BC
  18. LEFT OUTER JOIN question
  19. update with multiple fields as aggregates
  20. numbering rows on import from file
  21. columns for count histograms of values
  22. Field Alias Alternative
  23. Reg:-How to make relationship more one table in PgSQL
  24. information_schema.referential_constraints permissions
  25. currval of sequence "my_seq" is not yet defined in this session
  26. Truncate table at a certain size.
  27. psql: no schema info
  28. Curious about wide tables.
  29. Protection from SQL injection
  30. Simple error "exception when" in trigger
  31. trim(both) problem?
  32. Re: How I can check a substring is a valid number in postgresql ?
  33. How I can check a substring is a valid number in postgresql ?
  34. First day of month, last day of month
  35. extracting words
  36. Problem with FOREIGN KEY
  37. Updating with a subselect
  38. After updating dataset the record goes to the end of the dataset
  39. Problems with function while migrating from Windows to Linux
  40. Having a mental block with (self) outer joins
  41. Error: could not find pathkey item to sort
  42. Re: Desc Commnad in pgsql?
  43. Re: Error in restore the Database in Postgres
  44. triggers order
  45. subselect with group by
  46. error codes
  47. Desc Commnad in pgsql?
  48. SQL/XML Multi table join question
  49. What does mod - in "mod statement" - stand for?
  50. using string functions on plpgsql
  51. Index on elements of an array
  52. Data Comparison Single Table Question
  53. Re: export CSV file through Java JDBC
  54. Multiple databases
  55. How to find double entries
  56. export CSV file through Java JDBC
  57. rule for update view that updates/inserts into 2 tables
  58. Get the last inserted id
  59. Testing for null record in plpgsql
  60. Timestamp
  61. (no subject)
  62. dateformat issue
  63. count question
  64. advocacy: case studies
  65. Pattern Matchig
  66. how to returns set of records in PL/python
  67. Commit every processed record
  68. undefined relations in pg_locks
  69. pl/PgSQL, variable names in NEW
  70. Problem commit in function
  71. Problem with now() in function pgsql
  72. foreign key to "compound foreign key table"
  73. BROBLEM IN BETWEEN QUERY (plpgsql)
  74. GiST/GIN index for field of type VARCHAR[]
  75. connections between servers
  76. Asking GO on SQL SERVER
  77. A sys func for a->b, b->c => a->c ?
  78. Avoiding sub-query with group by
  79. Efficiency of sub-query with "order by"
  80. update with join
  81. apparent RI bug
  82. difference between EXCEPT and NOT IN?
  83. Sequential non unique IDs
  84. drop table where tableName like 'backup_2007%' ?
  85. specifying wal file size
  86. LIMIT and OFFSET question
  87. link to Jsp
  88. returning on inserts
  89. Removing redundant itemsets
  90. Re: FW: Re: Part 1 of several - Converting a varchar to an interval
  91. Re: FW: Re: Part 1 of several - Converting a varchar to an interval
  92. Bizarre sort order
  93. Re: FW: Re: Part 1 of several - Converting a varchar to an interval
  94. Finding all References to a Primary Key
  95. Re: Part 1 of several - Converting a varchar to an interval
  96. FW: Re: Question 2 Interval and timestamptz
  97. Re: Question 2 Interval and timestamptz
  98. FW: Re: Part 1 of several - Converting a varchar to an interval
  99. copy command and array of composite types?
  100. Part 1 of several - Converting a varchar to an interval
  101. Question 2 Interval and timestamptz
  102. Export Access 97 to PostgreSQL
  103. Table Schema
  104. Re: Table schema
  105. Deferrable NOT NULL REFERENCES ... for two-way referential relationship
  106. Subselect strange behaviour - bug?
  107. Testing DDL
  108. SOLVED - Re: Dynamic sql and variable record types
  109. DB Design
  110. cursors and sessions
  111. Counting days ...
  112. in() VS exists()
  113. Timestamp, epoch and a bit confusion
  114. Using index with array ANY operator
  115. Re: Insert problem
  116. Re: works but ...
  117. case when... end in update clause?
  118. Insert problem
  119. UPDATE .. FROM
  120. plpythonu + os.spawnv
  121. query results in XML format?
  122. Composite UNIQUE across two tables?
  123. Bit string help, please
  124. RETURN QUERY generates error
  125. Re: using copy from in function
  126. finding columns that have three or fewer distinct characters
  127. Re: Documenting a DB schema
  128. using copy from in function
  129. Re: Documenting a DB schema
  130. Re: Documenting a DB schema
  131. psql word wrapping to terminal width - testers?
  132. Re: php to pgsql question
  133. compiling plpython compilation error
  134. pl/pgsql and error handling
  135. Re: Function returns error (view) (RESOLVED)
  136. operator class
  137. Subselects returning array and ANY...
  138. REFERENCES and INHERITS restrictions?
  139. how do I get table DDL from psql (not from pg_dump)
  140. duplicate key violates unique constraint
  141. Function returns error (view)
  142. Re: Deploying PostgreSQL on virtualized hardware
  143. Bounce test
  144. autovacuum not freeing up unused space on 8.3.0
  145. function to compare a string
  146. Delete with foreign keys
  147. SQL standards in Mysql
  148. postgresql function not accepting null values in select statement
  149. cross-schema view
  150. Data layer migration from MSSQL
  151. Re: Proposed archival read only trigger on rows - preventhistory modification
  152. undefined relations in pg_locks
  153. Escaping of RegEx?
  154. Re: Helper aggregate function
  155. Except without elimination of non-distinct rows
  156. Re: Except without elimination of non-distinct rows
  157. ignore NULL FKs
  158. Opposite of "not in"
  159. can a insert with a returning clause be subquery ?
  160. Helper aggregate function
  161. aggregate reverse
  162. Re: Problem with the to_timestamp function
  163. SQL tree duplication
  164. date format
  165. ALTER TABLE <mytable> DROP CONSTRAINT IF EXISTS <myconstraint> ?
  166. Re: improvements to query with hierarchical elements
  167. currval() within one statement
  168. TIMESTAMP comparison problem
  169. improvements to query with hierarchical elements
  170. Having elements of an int[]-array reference other tables
  171. transaction and triggers
  172. How to test/read a stored procedure that returns a boolean?
  173. obtaining the query string inside a trigger
  174. SQL dealing with subquery comparison
  175. Update PK Violation
  176. SQL dealing with subquery
  177. Is DATETIME an ANSI-SQL type?
  178. Re: UTF8 encoding and non-text data types
  179. Unescaping text or binary file
  180. table column names - search
  181. Re: UTF8 encoding and non-text data types
  182. UTF8 encoding and non-text data types
  183. Re: UTF8 encoding and non-text data types
  184. SQL question: Highest column value of unique column pairs
  185. SQL stored function inserting and returning data in a row.
  186. (possible) bug with constraint exclusion
  187. Re: JOIN a table twice for different values in the same query
  188. Re: trigger for TRUNCATE?
  189. Escape sequence for UTF-8 Character Literals?
  190. JOIN a table twice for different values in the same query
  191. Shorthand column labels (SELECT col1 foo, ...) vs (SELECT col1 ASfoo, ...)
  192. Support for SQL TOP clause?
  193. Re: How to keep at-most N rows per group? periodic DELETEs orconstraints or..?
  194. trigger for TRUNCATE?
  195. Re: How to keep at-most N rows per group? periodic DELETEs orconstraints or..?
  196. How to keep at-most N rows per group? periodic DELETEs or constraints or..?
  197. Get the max(value1, value2, value3) from a table
  198. reading WAL files in python
  199. Cheers for DISTINCT ON
  200. WAL archiving blowed.
  201. tsearch2: ts_headline performance problem
  202. Re: Argentinian timezone change at the last moment. How to change pgsql tz db?
  203. PG is in different timezone than the OS
  204. Using rules to implement backward-compatible schema changes
  205. M,I-5 Pers ecution Thr ee Years of MI5 P ersecution Fax es
  206. M`I 5`Pe rsecution . MI5 Wan t Me to Send Yo u the se Fa xes
  207. M I.5 Perse cution MI 5 Insi st tha t th ese Fax es mu st Continu e
  208. M I`5'Pers ecution , 22, 544 + 837 = 23,38 1
  209. Limit # of recs on inner join?
  210. M`I'5`Per secution ` Molestatio n durin g Tr avel
  211. M I`5,P ersecution M I5 a re A fraid to Adm it T heyre Behi nd the Persecution
  212. M`I'5`Persecu tion ` No Justic e f or the Vic tims of MI 5
  213. M-I'5.Persecuti on . MI 5 H ave Syst ematically Destroy ed My Life
  214. M'I.5,Perse cution Haras sment t hrough the Radio
  215. Re: temp table existence
  216. PL/pgsql: function passing argument to IN operator
  217. temp table existence
  218. sql query question ?
  219. how to use pgsql like mssql
  220. Re: how to use pgsql like mssql
  221. M I-5 Persec ution ' BB C Newscasters L ie & Deny T heyre Watchi ng Me
  222. need help
  223. Re: need help
  224. M I-5 Pe rsecution , MI5 Wa ste Taxpa yer Millio ns on Poi ntless Hate-Campaig n
  225. M'I.5 Perse cution , F our Ye ars of M I5 Per secution P osts on Intern et Newsgroup s
  226. Advice for generalizing trigger functions
  227. M`I'5-Persecut ion . C omparing t he M I5 P ersecution wi th G erman Final Solut ion
  228. slow query - only uses indices
  229. Different Query plans filtering between dates
  230. returning an array as a list fo single-column rows?
  231. Misnamed field in subquery does not cause error when field name exists in parent query
  232. Concatenation through SQL
  233. sql query - create replace function
  234. DBLink or setof record functions & type shortcuts
  235. trigger problem with an if statement
  236. Re: Describe Table
  237. System catalog future changes
  238. Insert into and Sequence
  239. Bad count of rows estimated for emerge join
  240. Describe Table
  241. passing a multiple join to a function?
  242. SELECT MAX returns wrong value
  243. odd error updating - varchar
  244. Re: Query design assistance - getting daily totals
  245. Trigger definition . . . puzzled
  246. Re: Trigger definition . . . puzzled
  247. Query Assistance
  248. Function result using execute
  249. Query design assistance - getting daily totals
  250. Re: case sensitivity for tables, columns, and constraint names