PDA

View Full Version : pgsql Sql

Pages : 1 2 [3] 4 5 6 7 8 9 10 11 12 13 14
  1. work hour calculations
  2. Re: Trigger to change different row in same table
  3. 8.0.1 to 8.0.13 upgrade added 15% lack of time of query execution
  4. Use of delete...returning in function problem
  5. EXECUTE 'EXECUTE ...' or how to use dynamic prepared statements ?
  6. Difference between "foo is false" and "foo=false"? Partial indexon boolean.
  7. Re: Request into several DBMS simultaneously on DDL and DML
  8. Re: Execute SQL statements with 'context'/predefined variables
  9. Cast on character columns in views
  10. Execute SQL statements with 'context'/predefined variables
  11. Speeding up schema changes
  12. PK & FK & Index Question
  13. Re: pg & Delphi
  14. Re: Request into several DBMS simultaneously on DDL and DML
  15. How to influence the planner
  16. Re: Incomprehensible dogged sort in Merge Join
  17. Re: Incomprehensible dogged sort in Merge Join
  18. Reporting functions (OLAP)
  19. date problems
  20. Postgres 7.4 function
  21. Add more than one column to a query result, with a single function
  22. Was: fetch first rows of grouped data
  23. Re: Database normalization
  24. pg & Delphi
  25. Request into several DBMS simultaneously on DDL and DML
  26. fetch first rows of grouped data
  27. SQL function
  28. Re: [GENERAL] table column vs. out param [1:0]
  29. List of FKeys ?
  30. Block size with pg_dump?
  31. Returning array of IDs as a sub-query with group-by
  32. MI5 Persecution: Neil Fox (March/1998) (5999)
  33. MI5 Persecution: Capital Radio (11/April/1997) (4776)
  34. MI5 Persecution: GLR: David Hepworth (9/May/1997) (3553)
  35. MI5 Persecution: GLR: David Hepworth (21/Feb/1997) (2330)
  36. MI5 Persecution: Life is so hard (1107)
  37. MI5 Persecution: BBC1 TV News - 18/Dec/2002 (8445)
  38. MI5 Persecution: Channel Four TV News - 10/April/2002 (7222)
  39. MI5 Persecution: BBC-TV See You, See Me - 7/Dec/2001 (5999)
  40. MI5 Persecution: C4 SnowMail - January/2001 (4776)
  41. MI5 Persecution: England expects every man to do his duty (3553)
  42. MI5 Persecution: Nicholas Witchell - 10/April/1999 (2330)
  43. MI5 Persecution: Chris Tarrant - 10/March/1999 (1107)
  44. SQL query to display like this
  45. minimum bounding circle for a triangle/polygon
  46. Re: Solution to retrieve first and last row for each minute
  47. Partial index and query plan
  48. Re: Solution to retrieve first and last row for each minute
  49. Re: raw data into table process
  50. Database creation script
  51. Re: Solution to retrieve first and last row for each minute
  52. Solution to retrieve first and last row for each minute
  53. raw data into table process
  54. Make a SQL statement not run trigger
  55. newbie : multiple join produces weird aggregate column results
  56. SELECT syntax synopsis: column_definition?
  57. Re: Join question
  58. Join question
  59. wrong answer
  60. MI5 Persecution: Channel Four TV News - 12/Feb/1999 (5999)
  61. MI5 Persecution: Dimbleby / John Major, April 1997 (4776)
  62. MI5 Persecution: Ken Clarke (2), April 1997 (3553)
  63. MI5 Persecution: Ken Clarke (1), April 1997 (2330)
  64. MI5 Persecution: Overview (1107)
  65. MI5 Persecution: David Hepworth (2) 16/5/97 (18229)
  66. MI5 Persecution: Victor Lewis-Smith 9/5/97 (17006)
  67. MI5 Persecution: Continuing Silence 9/5/97 (15783)
  68. MI5 Persecution: Peak Practice 26/4/97 (14560)
  69. MI5 Persecution: I am being ignored 17/4/97 (13337)
  70. MI5 Persecution: Striking out action 10/3/97 (12114)
  71. MI5 Persecution: David Hepworth (1) 26/2/97 (10891)
  72. MI5 Persecution: No Justice 20/11/96 (9668)
  73. MI5 Persecution: WTGROMT 18/11/96 (8445)
  74. MI5 Persecution: Excellent web page 19/10/96 (7222)
  75. MI5 Persecution: Usual targets of such abuse 10/10/96 (5999)
  76. MI5 Persecution: Just too crazy 30/9/96 (4776)
  77. MI5 Persecution: Latest technology 31/7/96 (3553)
  78. MI5 Persecution: BBC+ITN=MI5 23/7/96 (2330)
  79. MI5 Persecution: Silly-billy 6/7/96 (1107)
  80. MI5 Persecution: Silly-billy 6/7/96 (5999)
  81. MI5 Persecution: Old_500 5/7/96 (4776)
  82. MI5 Persecution: alt.fan.mike-corley 6/6/96 (3553)
  83. MI5 Persecution: Bernard Levin 1/6/96 (2330)
  84. MI5 Persecution: Fitted up 26/4/96 (1107)
  85. TRIGGERS and FUNCTIONS
  86. problems with extension function in C
  87. MI5 Persecution: Fitted up 26/4/96 (1107)
  88. there is already a transaction in progress ?
  89. Join query help
  90. Sequences problem
  91. Limited number of polygon function arguments
  92. SUPERUSER vs CREATEUSER causes foul 'code smell'
  93. Starting autovacuum in postgresql-8.1.9
  94. Problem with phone list.
  95. Re: Boolean without default declared
  96. Boolean without default declared
  97. When is a shared library unloaded?
  98. Getting pk of the most recent row, in a group by
  99. how to moce back in refcursor
  100. Comparing two slices within one table efficiently
  101. Re: Install two different versions of postgres which shouldrun in parallel
  102. Trigger Procedure Error: NEW used in query that is not in a rule
  103. foreign key pointing to diff schema?
  104. Re: Install two different versions of postgres which shouldrun in parallel
  105. Index usage in order by with multiple columns in order-by-clause
  106. Join optimization
  107. Re: Using function like where clause
  108. Re: Returnd Refcurser (<unnamed portal x> not fetchable
  109. Re: Returnd Refcurser (<unnamed portal x> not fetchable
  110. Returnd Refcurser (<unnamed portal x> not fetchable
  111. Indexing a field of type point
  112. pg_trgm installation
  113. PG won't use index on ORDER BY <expression>
  114. Indexing a field of type point
  115. Performance on writable views
  116. Implementing an regex filter
  117. populate value of column
  118. Adding NOT NULL columns in PostgreSQL 7.4?
  119. Range of caracters
  120. Restricting columns by users
  121. Using function like where clause
  122. Best Fit SQL query statement
  123. Re: [GENERAL] could not [extend relation|write block N of temporary file|write to hash-join temporary file]
  124. Increment a sequence by more than one
  125. Re: Count of rows
  126. Count of rows
  127. Foreign Key inter databases
  128. GiST index implementation
  129. Authentification failed
  130. How do I connect postgres table structures and view structures to an existing svn repository?
  131. Alternative to INTERSECT
  132. Table-name as parameter to plpgsql
  133. Connection Limit
  134. hi
  135. Migration from SQLite Help (Left Join)
  136. increment the primary key value without using sequences
  137. raise exception and transaction handling
  138. group by range of values
  139. strange result for select * from table where id=random()*900
  140. Re: Join question
  141. problem join
  142. Join question
  143. unique index on fields with possible null values
  144. Tunning PostgreSQL performance for views on Windows
  145. How to cast, if type has spaces in the name
  146. Assistance with a trigger
  147. inheriting a rule or a trigger?
  148. is there a 'table' data type in pg?
  149. using regexp_replace
  150. The nested view from hell - Restricting a subquerry
  151. UNION and LIMIT issue
  152. Birth Day Calculation
  153. Database Synchronization
  154. A better look at trying to insert a Conditional in a SELECT statement
  155. Inserting an IF statement in the middle of a SELECT in pl/pgSQL code
  156. Having the sum of two queries
  157. data dependent sequences?
  158. Bitmap Index Scan
  159. calculation of pay based on dates
  160. calling webservice through postgresql function
  161. Query Plan
  162. Converting from MS Access field aliases
  163. Using case or if to return multiple rows
  164. using EXECUTE on Selects
  165. using EXECUTE on Selects
  166. linux
  167. Re: Index working, but not inside function
  168. Database system identifier from SQL
  169. record fields as columns in reports
  170. Is index usage in LIKE-queries with UTF-8 implemented in PG-8.3 ?
  171. Delete rules and functions
  172. Re: Vacation days
  173. Where clause
  174. Re: yet another simple SQL question
  175. Re: yet another simple SQL question
  176. NO DATA FOUND Exception
  177. Re: yet another simple SQL question
  178. Re: yet another simple SQL question
  179. Re: another simple SQL question
  180. simple SQL question
  181. Counting all rows
  182. MI5 Persecution: Stasi 21/4/96 (16305)
  183. MI5 Persecution: Leant On 7/4/96 (14791)
  184. MI5 Persecution: Shoot to Kill 4/4/96 (13277)
  185. MI5 Persecution: Email Cruelty 11/3/96 (11763)
  186. MI5 Persecution: Jeff Rooker MP 5/3/96 (10249)
  187. MI5 Persecution: Flight or fight 7/1/96 (8735)
  188. MI5 Persecution: A new Kafka? 3/10/95 (5707)
  189. MI5 Persecution: Do they fear truth? 3/10/95 (4193)
  190. MI5 Persecution: Grievous Bodily Harm 2/10/95 (2679)
  191. MI5 Persecution: Goldfish and Piranha 29/9/95 (1165)
  192. Re: Subquery problems
  193. Re: [Fwd: 47G file]
  194. Embedded C++ with ecpg?
  195. Transactions and Exceptions
  196. insert statement woes
  197. join problem
  198. Re: Select last there dates
  199. Results per letter query
  200. Re: Select last there dates
  201. Technique for turning time ranges into a graph
  202. commit failed when calling postgresql with ado
  203. start transaction failed
  204. Fwd: [pgsql-es-ayuda] Ejecutar \copy desde VB
  205. Subquery problems
  206. tsearch2() trigger and domain types...
  207. Setting Variable - (Correct)
  208. Setting variable
  209. Exec a text variable as select
  210. separating improperly grouped page views
  211. joining a table whose name is stored in the primary record
  212. trigger firing order
  213. Re: Organization of tables
  214. Random Unique Integer
  215. Organization of tables
  216. function to find difference between in days between two dates
  217. inner join problem with temporary tables
  218. calculate time diffs across rows with single timestamp
  219. join problem
  220. setof or array as input parameter to postgresql 8.2 functions
  221. sql server to postgreSQL
  222. Using INET types in prepared statements
  223. cluster index on primary key
  224. search path within trigger
  225. show index from [table]
  226. MI5 Persecution: Goldfish and Piranha 29/9/95 (5707)
  227. MI5 Persecution: Watch Out, Forger About 27/9/95 (4193)
  228. MI5 Persecution: Question and Answer 27/9/95 (2679)
  229. MI5 Persecution: Options 21/9/95 (1165)
  230. Re: [ADMIN] the right time to vacuum database?
  231. subtract a day from the NOW function
  232. How to find missing values across multiple OUTER JOINs
  233. Re: [GENERAL] CREATE RULE with WHERE clause
  234. Re: [GENERAL] CREATE RULE with WHERE clause
  235. JOIN
  236. Re: JOIN
  237. Inserting a path into Database
  238. Encrypted column
  239. current_date / datetime stuff
  240. Jumping Weekends
  241. pguuid for windows
  242. schema propagation
  243. Re: slow query execution
  244. Re: slow query execution
  245. ASK about SQL
  246. Re: slow query execution
  247. Re: slow query execution
  248. Re: slow query execution
  249. Re: slow query execution
  250. Re: slow query execution