PDA

View Full Version : pgsql Sql

Pages : 1 2 3 4 5 6 7 8 9 [10] 11 12 13 14
  1. pl/* overhead ...
  2. padding an integer ...
  3. ?Equiv to oracle (ENABLE|DISABLE) (CONSTRAINT|TRIGGER) statements?
  4. broken join optimization? (8.0)
  5. backend error
  6. Re: 8.0.x windows installer fails?
  7. 8.0.x windows installer fails?
  8. Re: convert timezone to string ...
  9. convert timezone to string ...
  10. SQL language
  11. how to create rule as on delete
  12. Article on Oracle & MySQL in E-week
  13. Re: how to create rule as on delete
  14. How much more would you earn?
  15. SQL Functions
  16. Re: automatic update or insert
  17. Re: how to create rule as on delete
  18. Aggregate versus lineitem report
  19. Re: SQL language
  20. (NONE)
  21. Re: Blank-padding
  22. (NONE)
  23. unsuscribe
  24. Merging lines with NULLs (with example data)
  25. Blank-padding (was: Oracle buys Innobase)
  26. Delete rule chain stops unexpectedly
  27. Postgres 7.4.9 slow!
  28. Problema con migracion de SQL a PostgreSQL
  29. Sql - Error : Relation tmp_datos already exists
  30. automatic update or insert
  31. casting character varying to integer - order by numeric sort
  32. Re: Problem -Postgre sql
  33. Character set error
  34. =?iso-8859-1?q?Sql=20-=20Error=20en=20ejecuci=F3n=20de=20funci=F3n=20Pos t?==?iso-8859-1?q?gres=20desde=20cliente=20VFoxPro?=
  35. Field Separator not working?
  36. Re: Double query (limit and offset)
  37. Re: Double query (limit and offset)
  38. writable joined view
  39. Re:
  40. Re: Problem -Postgre sql
  41. query to file
  42. Re: Problem -Postgre sql
  43. Re: Problem while using start transaction ans commit;
  44. problems with array
  45. Problem while using start transaction ans commit;
  46. What Am I Doing Wrong?
  47. Re: What Am I Doing Wrong?
  48. Consulta!
  49. Re: Question about functions
  50. Question about functions
  51. cast
  52. FULL OUTER JOIN Question (mistake)
  53. FULL OUTER JOIN Question
  54. owner of data type "areas" appears to be invalid ?
  55. sql function
  56. pgOleDb
  57. Re: pg, mysql comparison with "group by" clause
  58. Design problemi : using the same primary keys for inherited objects.
  59. copy table
  60. copy tables
  61. Re: pg, mysql comparison with "group by" clause
  62. Re: pg, mysql comparison with "group by" clause
  63. Re: pg, mysql comparison with "group by" clause
  64. Query information needed
  65. Storing images from Delphi to postgresql
  66. Re: pg, mysql comparison with "group by" clause
  67. UPDATE Trigger on multiple tables
  68. Re: pg, mysql comparison with "group by" clause
  69. Re: pg, mysql comparison with "group by" clause
  70. Re: pg, mysql comparison with "group by" clause
  71. Re: Update timestamp on update
  72. Re: SEVEN cross joins?!?!?
  73. Update timestamp on update
  74. Re: pg, mysql comparison with "group by" clause
  75. Re: regular expression
  76. Text->Date conversion in a WHERE clause
  77. Strange join...maybe some improvements???
  78. Very Urgent Req for SQL-DBS In Chennai
  79. Re: pg, mysql comparison with "group by" clause
  80. Returning NULL results?
  81. ichar
  82. Difference from average
  83. question re. count, group by, and having
  84. SEVEN cross joins?!?!?
  85. convert time
  86. generating a sequence table against which to do a LEFT OUTER JOIN
  87. How to delete Large Object from Database?
  88. RULES on SELECT with JDBC/perlDBI from other RDBMS products?
  89. Re: Selecting records not present in related tables
  90. Selecting records not present in related tables
  91. DATESTYLE and 0000-00-00
  92. Re: UNION index use help
  93. UNION index use help
  94. Noob question about types and lists
  95. catching errors in function
  96. Scripting GRANT on functions
  97. Re: Use of partial index
  98. Use of partial index
  99. Re: MOVE in SQL vs PLPGSQL
  100. Re: Help with simple SQL query?
  101. Help with simple SQL query?
  102. count(arg1, arg2) in pgsql
  103. query tables based on a query
  104. Getting user created tables from SQL
  105. creating postgres tables by passing a string to function
  106. MOVE in SQL vs PLPGSQL
  107. regular expression
  108. Re: using pg_tables and tablename in queries
  109. using pg_tables and tablename in queries
  110. Re: combination of function to simple query makes query slow
  111. Re: combination of function to simple query makes query slow
  112. BirthDay SQL Issue
  113. combination of function to simple query makes query slow
  114. EXECUTE SELECT INTO... last one!
  115. EXECUTE with SELECT INTO variable, or alternatives
  116. Re: Sending function parametars within EXECUTE ''SELECT...
  117. unsubscribe
  118. Selecting count of details along with details columns
  119. Problem with function and trigger...
  120. Sending function parametars within EXECUTE ''SELECT...
  121. Re: changing a column's position in table, how do you do that
  122. changing a column's position in table, how do you do that
  123. interval of 1 millisecond
  124. How to join tables in different databases?
  125. Re: how to do 'deep queries'?
  126. Re: how to do 'deep queries'?
  127. Re: how to do 'deep queries'?
  128. Why doesn't the SERIAL data type automatically have a UNIQUE CONSTRAINT
  129. Re: how to do 'deep queries'?
  130. how to do 'deep queries'?
  131. add column if doesn't exist
  132. Possible to delete record from all tables at the same time?
  133. redundancy in CHECK CONSTRAINTs
  134. stored procs in postgresql
  135. VACUUM FULL vs dump & restore
  136. Re: [ADMIN] COPY TO / COPY FROM
  137. Where are user defined functions stored?
  138. Re: Functions, transactions and RETURN
  139. Issue with UPDATE statement on v8
  140. Difficulties with a master-detail query
  141. Functions, transactions and RETURN
  142. Primary and Foreign Key?
  143. Re: Help with a view
  144. Issue with UPDATE statement on v8
  145. Re: Help with a view
  146. Help with a view
  147. Using descriptor areas to insert
  148. postgres on the comman line
  149. Updating cidr column with network operator
  150. Copy Views From Database?
  151. delete item[5] from varchar[] array???
  152. Re: R-tree and start/end queries
  153. R-tree and start/end queries
  154. How to add column from old_table to new_table?
  155. Re: Inheritance (general hints wanted)
  156. Inheritance (general hints wanted)
  157. unsuscribe
  158. Re: How to install Postgresql 8 on different drive letter?
  159. plpgsql function not accepting NULL value
  160. alter sequence + subqueries
  161. How to install Postgresql 8 on different drive letter?
  162. passing values into .sql scripts
  163. Triggers & Conditional Assignment
  164. showing multiple REFERENCE details of id fields in single query thatshare the same table
  165. CREATE TEMPORARY TABLE ON COMMIT DROP
  166. What should this query match?
  167. URGENT need help 8.0.3 on Win 32
  168. Age in days
  169. How do I convert an integet to a timestamp?
  170. refer a column as a varible name?
  171. Please help, can't figure out what's wrong with this function...
  172. howto insert dynamic value
  173. showing multiple reference details from single query
  174. Panic: Page Add Item: Corrupted page pointers
  175. Need help with 'unique parents' constraint
  176. Fwd: how to have 2 select creteria on one column? SOLVED
  177. how to update with a join?
  178. how to have 2 select creteria on one column?
  179. SELECT: retrieve only 2 rows next to known row
  180. Numeric Columns
  181. Re: how to replace
  182. Re: how to replace
  183. how to replace
  184. a "catch all" type ... such a thing?
  185. Re: Indexing an array?
  186. Indexing an array?
  187. user defined type, plpgsql function and NULL
  188. column names, types, properties for a table
  189. Re: uuid type (moved from HACKERS)
  190. Help with multistage query
  191. AGE function
  192. Statistics from Sequences
  193. Re: Table Constraint CHECK(SELECT()) alternative?
  194. Re: Table Constraint CHECK(SELECT()) alternative?
  195. ERROR: syntax error at or near "select" at character 9
  196. Searching for results with an unknown amount of data
  197. Weird Trigger Behaviour using IF ... THEN ... ESLEIF... THEN... ELSEIF... THEN ... ELSE ... END IF;
  198. Equivalent of Oracle SQL%NOTFOUND in plpgsql
  199. POSIX Regular Expression question
  200. Help with UNION query
  201. joining two simular (but not identical tables)
  202. Searching for results with an unknown amount of data
  203. Recommendation on bytea or blob for binary data like images
  204. Re: Turn off auto-commit
  205. Turn off auto-commit
  206. not sure about constraints
  207. cursor "<unnamed portal 1>" already in use
  208. Returning with the inserted id
  209. queries problems
  210. Re: [HACKERS] ALTER TABLE ( smallinto -> boolean ) ...
  211. Re: [HACKERS] ALTER TABLE ( smallinto -> boolean ) ...
  212. insert only if conditions are met?
  213. =?ISO-8859-1?Q?psql_commandline?=
  214. How do I copy part of table from db1 to db2 (and rename thecolumns)?
  215. Re: booleans and nulls
  216. Re: question
  217. Re: Time differences between rows, not columns?
  218. Re: Time differences between rows, not columns?
  219. Re: Time differences between rows, not columns?
  220. Time differences between rows, not columns?
  221. Performance issue
  222. sqlstate 02000 while declaring cursor/freeing prepared statements
  223. PostgreSQL help
  224. Re: Unwanted nested dollar-quoted constants
  225. Re: nullif('','') on insert
  226. Re: booleans and nulls
  227. returning inserted id
  228. Numerical variables in pqsql statements
  229. question
  230. Common patterns for 'store' functions
  231. Tidying values on variable instantiation
  232. Re: How this query!
  233. table listing queries
  234. Can EXCEPT Be Used for To Solve This Problem?
  235. How to join several selects
  236. SQLException - SET AUTOCOMMIT TO OFF is no longer supported
  237. Re: Number of rows in a cursor ?
  238. Number of rows in a cursor ?
  239. Re: Problem calling stored procedure
  240. Re: Problem calling stored procedure
  241. Re: Problem calling stored procedure
  242. Tuple insert missing query in ongoing transaction
  243. Re: Problem calling stored procedure
  244. Re: diary constraints
  245. diary constraints
  246. Re: Why Doesn't SQL This Expression Work?
  247. Why Doesn't SQL This Expression Work?
  248. PL/SQL Function: self-contained transaction?
  249. Problem calling stored procedure
  250. Re: [ADMIN] Data insert