PDA

View Full Version : pgsql Sql

Pages : 1 2 [3] 4 5 6 7 8 9 10 11 12 13 14
  1. Returning an array from a subquery
  2. hidden versioning system
  3. JOINing based on whether an IP address is contained within a CIDR range?
  4. Re: ERROR: failed to re-find parent key in "pk_ep07"
  5. (repost) Help understanding expressions in order by clause
  6. ERROR: failed to re-find parent key in "pk_ep07"
  7. get only rows for latest version of contents
  8. Re: get only rows for latest version of contents
  9. Quick question re foreign keys.
  10. request for help with COPY syntax
  11. backup database tablespace with rsync?
  12. two queryes in a single tablescan
  13. when inserting to table, text type parameter become NULL (after big assignment to this parameter)
  14. what's wrong with my date comparison?
  15. Having difficulty writing a "best-fit" query..
  16. Inconsistent sql result
  17. How to escape a memo field as a binary value in postgresql
  18. OT: array_accum equivalent in Oracle
  19. Accessing field of OLD in trigger
  20. Re: Refactored queries needing validation of syntactic equivalence
  21. seg data type
  22. Computed table name in function
  23. array handling on 8.0.3
  24. Get different sums from the same table in one query
  25. pg_dump question
  26. Re: [ADMIN] Postgres Array Traversing Problem
  27. Re: Rule Error
  28. What SQL is running against my DB?
  29. Rule Error
  30. UNIQUEness and time interval
  31. Why does the sequence skip a number with generate_series?
  32. field separator problem
  33. Need help with CASE statement in Function
  34. Finding broken regex'es
  35. Populate unique column with default value
  36. to restore database in schema
  37. Problems with bulk update
  38. Function parameters
  39. one entry per group?
  40. problems with copy
  41. foreign key problem
  42. How pull
  43. Intermittent Empty return
  44. Many databases
  45. SQL query question
  46. Table transform query
  47. error dropping operator
  48. SQL performance help: self join or static var
  49. Format intervall as hours/minutes etc
  50. Optimize querry sql
  51. Watch Satellite TV On Your PC
  52. Optimize querry sql
  53. Optimize querry sql
  54. Index usage in bitwise operation context
  55. unique constratin - not in the table
  56. Re: Extracting hostname from URI column
  57. Re: Extracting hostname from URI column
  58. Extracting hostname from URI column
  59. Simple Query?
  60. select sum within transaction problem
  61. Does postgresql8.2 supports multithreading?
  62. postgresql HEAD build failure
  63. Function Volatility
  64. SERIAL type's sequence is double-called or ?
  65. Re: Failing join with set returning function
  66. Failing join with set returning function
  67. to_date function
  68. How to use serial variable to insert into muiti-recrods?
  69. recursive query
  70. tsearch2 query question
  71. ISO time zone format
  72. work hour calculations
  73. Re: Trigger to change different row in same table
  74. 8.0.1 to 8.0.13 upgrade added 15% lack of time of query execution
  75. Use of delete...returning in function problem
  76. EXECUTE 'EXECUTE ...' or how to use dynamic prepared statements ?
  77. Difference between "foo is false" and "foo=false"? Partial indexon boolean.
  78. Re: Request into several DBMS simultaneously on DDL and DML
  79. Re: Execute SQL statements with 'context'/predefined variables
  80. Cast on character columns in views
  81. Execute SQL statements with 'context'/predefined variables
  82. Speeding up schema changes
  83. PK & FK & Index Question
  84. Re: pg & Delphi
  85. Re: Request into several DBMS simultaneously on DDL and DML
  86. How to influence the planner
  87. Re: Incomprehensible dogged sort in Merge Join
  88. Re: Incomprehensible dogged sort in Merge Join
  89. Reporting functions (OLAP)
  90. date problems
  91. Postgres 7.4 function
  92. Add more than one column to a query result, with a single function
  93. Was: fetch first rows of grouped data
  94. Re: Database normalization
  95. pg & Delphi
  96. Request into several DBMS simultaneously on DDL and DML
  97. fetch first rows of grouped data
  98. SQL function
  99. Re: [GENERAL] table column vs. out param [1:0]
  100. List of FKeys ?
  101. Block size with pg_dump?
  102. Returning array of IDs as a sub-query with group-by
  103. MI5 Persecution: Neil Fox (March/1998) (5999)
  104. MI5 Persecution: Capital Radio (11/April/1997) (4776)
  105. MI5 Persecution: GLR: David Hepworth (9/May/1997) (3553)
  106. MI5 Persecution: GLR: David Hepworth (21/Feb/1997) (2330)
  107. MI5 Persecution: Life is so hard (1107)
  108. MI5 Persecution: BBC1 TV News - 18/Dec/2002 (8445)
  109. MI5 Persecution: Channel Four TV News - 10/April/2002 (7222)
  110. MI5 Persecution: BBC-TV See You, See Me - 7/Dec/2001 (5999)
  111. MI5 Persecution: C4 SnowMail - January/2001 (4776)
  112. MI5 Persecution: England expects every man to do his duty (3553)
  113. MI5 Persecution: Nicholas Witchell - 10/April/1999 (2330)
  114. MI5 Persecution: Chris Tarrant - 10/March/1999 (1107)
  115. SQL query to display like this
  116. minimum bounding circle for a triangle/polygon
  117. Re: Solution to retrieve first and last row for each minute
  118. Partial index and query plan
  119. Re: Solution to retrieve first and last row for each minute
  120. Re: raw data into table process
  121. Database creation script
  122. Re: Solution to retrieve first and last row for each minute
  123. Solution to retrieve first and last row for each minute
  124. raw data into table process
  125. Make a SQL statement not run trigger
  126. newbie : multiple join produces weird aggregate column results
  127. SELECT syntax synopsis: column_definition?
  128. Re: Join question
  129. Join question
  130. wrong answer
  131. MI5 Persecution: Channel Four TV News - 12/Feb/1999 (5999)
  132. MI5 Persecution: Dimbleby / John Major, April 1997 (4776)
  133. MI5 Persecution: Ken Clarke (2), April 1997 (3553)
  134. MI5 Persecution: Ken Clarke (1), April 1997 (2330)
  135. MI5 Persecution: Overview (1107)
  136. MI5 Persecution: David Hepworth (2) 16/5/97 (18229)
  137. MI5 Persecution: Victor Lewis-Smith 9/5/97 (17006)
  138. MI5 Persecution: Continuing Silence 9/5/97 (15783)
  139. MI5 Persecution: Peak Practice 26/4/97 (14560)
  140. MI5 Persecution: I am being ignored 17/4/97 (13337)
  141. MI5 Persecution: Striking out action 10/3/97 (12114)
  142. MI5 Persecution: David Hepworth (1) 26/2/97 (10891)
  143. MI5 Persecution: No Justice 20/11/96 (9668)
  144. MI5 Persecution: WTGROMT 18/11/96 (8445)
  145. MI5 Persecution: Excellent web page 19/10/96 (7222)
  146. MI5 Persecution: Usual targets of such abuse 10/10/96 (5999)
  147. MI5 Persecution: Just too crazy 30/9/96 (4776)
  148. MI5 Persecution: Latest technology 31/7/96 (3553)
  149. MI5 Persecution: BBC+ITN=MI5 23/7/96 (2330)
  150. MI5 Persecution: Silly-billy 6/7/96 (1107)
  151. MI5 Persecution: Silly-billy 6/7/96 (5999)
  152. MI5 Persecution: Old_500 5/7/96 (4776)
  153. MI5 Persecution: alt.fan.mike-corley 6/6/96 (3553)
  154. MI5 Persecution: Bernard Levin 1/6/96 (2330)
  155. MI5 Persecution: Fitted up 26/4/96 (1107)
  156. TRIGGERS and FUNCTIONS
  157. problems with extension function in C
  158. MI5 Persecution: Fitted up 26/4/96 (1107)
  159. there is already a transaction in progress ?
  160. Join query help
  161. Sequences problem
  162. Limited number of polygon function arguments
  163. SUPERUSER vs CREATEUSER causes foul 'code smell'
  164. Starting autovacuum in postgresql-8.1.9
  165. Problem with phone list.
  166. Re: Boolean without default declared
  167. Boolean without default declared
  168. When is a shared library unloaded?
  169. Getting pk of the most recent row, in a group by
  170. how to moce back in refcursor
  171. Comparing two slices within one table efficiently
  172. Re: Install two different versions of postgres which shouldrun in parallel
  173. Trigger Procedure Error: NEW used in query that is not in a rule
  174. foreign key pointing to diff schema?
  175. Re: Install two different versions of postgres which shouldrun in parallel
  176. Index usage in order by with multiple columns in order-by-clause
  177. Join optimization
  178. Re: Using function like where clause
  179. Re: Returnd Refcurser (<unnamed portal x> not fetchable
  180. Re: Returnd Refcurser (<unnamed portal x> not fetchable
  181. Returnd Refcurser (<unnamed portal x> not fetchable
  182. Indexing a field of type point
  183. pg_trgm installation
  184. PG won't use index on ORDER BY <expression>
  185. Indexing a field of type point
  186. Performance on writable views
  187. Implementing an regex filter
  188. populate value of column
  189. Adding NOT NULL columns in PostgreSQL 7.4?
  190. Range of caracters
  191. Restricting columns by users
  192. Using function like where clause
  193. Best Fit SQL query statement
  194. Re: [GENERAL] could not [extend relation|write block N of temporary file|write to hash-join temporary file]
  195. Increment a sequence by more than one
  196. Re: Count of rows
  197. Count of rows
  198. Foreign Key inter databases
  199. GiST index implementation
  200. Authentification failed
  201. How do I connect postgres table structures and view structures to an existing svn repository?
  202. Alternative to INTERSECT
  203. Table-name as parameter to plpgsql
  204. Connection Limit
  205. hi
  206. Migration from SQLite Help (Left Join)
  207. increment the primary key value without using sequences
  208. raise exception and transaction handling
  209. group by range of values
  210. strange result for select * from table where id=random()*900
  211. Re: Join question
  212. problem join
  213. Join question
  214. unique index on fields with possible null values
  215. Tunning PostgreSQL performance for views on Windows
  216. How to cast, if type has spaces in the name
  217. Assistance with a trigger
  218. inheriting a rule or a trigger?
  219. is there a 'table' data type in pg?
  220. using regexp_replace
  221. The nested view from hell - Restricting a subquerry
  222. UNION and LIMIT issue
  223. Birth Day Calculation
  224. Database Synchronization
  225. A better look at trying to insert a Conditional in a SELECT statement
  226. Inserting an IF statement in the middle of a SELECT in pl/pgSQL code
  227. Having the sum of two queries
  228. data dependent sequences?
  229. Bitmap Index Scan
  230. calculation of pay based on dates
  231. calling webservice through postgresql function
  232. Query Plan
  233. Converting from MS Access field aliases
  234. Using case or if to return multiple rows
  235. using EXECUTE on Selects
  236. using EXECUTE on Selects
  237. linux
  238. Re: Index working, but not inside function
  239. Database system identifier from SQL
  240. record fields as columns in reports
  241. Is index usage in LIKE-queries with UTF-8 implemented in PG-8.3 ?
  242. Delete rules and functions
  243. Re: Vacation days
  244. Where clause
  245. Re: yet another simple SQL question
  246. Re: yet another simple SQL question
  247. NO DATA FOUND Exception
  248. Re: yet another simple SQL question
  249. Re: yet another simple SQL question
  250. Re: another simple SQL question