PDA

View Full Version : pgsql Sql

Pages : 1 2 3 [4] 5 6 7 8 9 10 11 12 13 14
  1. Organization of tables
  2. function to find difference between in days between two dates
  3. inner join problem with temporary tables
  4. calculate time diffs across rows with single timestamp
  5. join problem
  6. setof or array as input parameter to postgresql 8.2 functions
  7. sql server to postgreSQL
  8. Using INET types in prepared statements
  9. cluster index on primary key
  10. search path within trigger
  11. show index from [table]
  12. MI5 Persecution: Goldfish and Piranha 29/9/95 (5707)
  13. MI5 Persecution: Watch Out, Forger About 27/9/95 (4193)
  14. MI5 Persecution: Question and Answer 27/9/95 (2679)
  15. MI5 Persecution: Options 21/9/95 (1165)
  16. Re: [ADMIN] the right time to vacuum database?
  17. subtract a day from the NOW function
  18. How to find missing values across multiple OUTER JOINs
  19. Re: [GENERAL] CREATE RULE with WHERE clause
  20. Re: [GENERAL] CREATE RULE with WHERE clause
  21. JOIN
  22. Re: JOIN
  23. Inserting a path into Database
  24. Encrypted column
  25. current_date / datetime stuff
  26. Jumping Weekends
  27. pguuid for windows
  28. schema propagation
  29. Re: slow query execution
  30. Re: slow query execution
  31. ASK about SQL
  32. Re: slow query execution
  33. Re: slow query execution
  34. Re: slow query execution
  35. Re: slow query execution
  36. Re: slow query execution
  37. Re: slow query execution
  38. slow query execution
  39. logging amount rows retrieved?
  40. spi and error messages
  41. problems with SELECT query results
  42. Recursively traversing a partially ordered set
  43. aggregate query
  44. group by day
  45. off topic
  46. Potential bug in postgres 8.2.4
  47. FATAL: cache lookup failed for function 1003
  48. system table storing sequence attributes
  49. How can you generate a counter for ordered sets?
  50. ignoring primary key violations in COPY command
  51. doubt
  52. ignoring primary key violations in COPY command
  53. Re: Whole-row comparison ?
  54. Whole-row comparison ?
  55. Adding "on delete cascade" to all foreign key constraints
  56. SQL Query Validate Records Multiple Tables - Help Needed
  57. Serial number of a record
  58. workday function
  59. How to process inverted comma in "EXECUTE 'insert into xxx values(...)';"?
  60. Doing a conditional aggregate (e.g. count(*) if x=y) in postgres?
  61. pg_dump?
  62. How to retrieve a n-ary tree in SQL?
  63. select ..... not in .....
  64. need help
  65. Funny date-sorting task
  66. check_constraint and Extract not working?
  67. Convert serial column to regular integer
  68. PL/PGSQL Record type question
  69. Re: Count rows by day interval
  70. insert a sequence
  71. Passing input to a view?
  72. query to select a linked list
  73. Needs Query
  74. Query RE using COPY
  75. Re: Error: Input string was not in a correct format
  76. Error: Input string was not in a correct format
  77. Temporal Table Relations and Referential Integrity
  78. syntax error in "createdb"
  79. How to use function PointN?
  80. ROW_NUMBER alias
  81. Sequence vs. Index Scan
  82. select slows from 3 seconds to 30 seconds
  83. Insert into VIEW using RULE. Not possible to use nextval()?
  84. Needs Function
  85. Needs Function
  86. Joe Celko's method to "generate_series" not working?
  87. Possible to access value in RECORD without knowing column name?
  88. table juxtaposition
  89. "is not distinct from" syntax error?
  90. Dynamic prepare possible in plpgsql?
  91. NEW to plpythonu function?
  92. Recursive query for Product Tree
  93. Selecting rows with "static" ordering
  94. plperlu hash problem
  95. Add constraint for number of chars
  96. sql wrapped plpgsql set returning function
  97. Which function transform x,y to latitude/longitude?
  98. Re: hi
  99. Query Join Performance
  100. plpgsql array looping
  101. Re: Function to return a multiple colmn table or view
  102. hi
  103. How to get text representation of composite value?
  104. Function returns zero
  105. Large journal as psql table. Good idea? Triggering.
  106. Large journal as psql table. Good idea? Triggering.
  107. plperlu hash problem
  108. Windows postgres
  109. Regular Expression Data Type
  110. Retrieve month from date in SQl query
  111. Split String Into Multiple Records
  112. Question on interval
  113. Function to return a multiple colmn table or view
  114. Retrieve month from date
  115. many 'OR' in WHERE-condition
  116. Doing a conditional insert/update
  117. slowness when subselect uses DISTINCT
  118. equiv of ascii() function for unicode?
  119. Problem using chr() for extended ASCII
  120. Re: Floating point type to store numbers
  121. Re: Floating point type to store numbers
  122. Re: Floating point type to store numbers
  123. quesion on functions calling from php
  124. How can I know if a row is Locked?
  125. We all are looped on Internet: request + transport = invariant
  126. question on plpgsql block
  127. replace EXCEPT by JOIN
  128. ERROR: column "crc" does not exist
  129. un-triviality is saved
  130. Replace string
  131. update from and left join
  132. Question about undefinably query...
  133. Newbie: Retrieving the oldest date in three tables?
  134. new idea
  135. Using variables combined to create a VIEW name
  136. MD5 sums of large objects
  137. Re: rowcount function in postgres???
  138. PlPg/SQL mulit-array as a parameter?
  139. dropping a schema and cross-schema dependencies
  140. Update Field with function/data from other tables?
  141. Re: Insert only if not found
  142. auto vacuuming
  143. Another date range join problem
  144. LOG: unexpected EOF on client connection
  145. Insert only if not found
  146. slow query
  147. Setting high performance on huge server
  148. CPU statistics
  149. Generating dates prior to generate_series
  150. Moving a simple function to pl/pgsql (Novice question)
  151. Re: plpgsql function question
  152. Re: [pgsql-sql] Daily digest v1.2492 (19 messages)
  153. Re: plpgsql function question
  154. Re: plpgsql function question
  155. A long-running transaction
  156. LOCK command inside a TRANSACTION
  157. best way: diary functions.
  158. Serial
  159. Very slow DELETE on 4000 rows of 55000 row table
  160. Re: [HACKERS] timestamp subtraction (was Re: formattingintervals with to_char)
  161. Maxusers MaxConnections
  162. SQL4. I ask you to help in development (or critic).
  163. Column alias based on a field
  164. Update problem.
  165. Update problem.
  166. Calling void functions
  167. How To Use EXISTS in plpgsql
  168. Sequence vs Serial
  169. PlPg/SQL 3 or more rows return
  170. Re: plpgsql function return array
  171. function return array
  172. using sql on v7.4 server to feed stored procedure
  173. Re: olympics ranking query
  174. Re: Empty Table
  175. Empty Table
  176. Temp tbl Vs. View
  177. SELECT INSTEAD
  178. Track query status
  179. How too select different views using a IF/THEN/ELSE procedure ?
  180. Rules with sequence columns
  181. union with count?
  182. Foreign Unique Constraint
  183. select vs. select count
  184. array_to_string
  185. Shared Buffers
  186. Selecting different views from a Boolean expression
  187. Dummy question
  188. unsubscribe
  189. Re: growth of the database
  190. Subqueryes
  191. Re: Subqueryes
  192. Re: Subqueryes
  193. Re: Monitor what command is executing at the backend
  194. Re: Monitor what command is executing at the backend
  195. Re: Issue with copying data from a text file.
  196. job opportunity
  197. Regular Expressions
  198. unsubscribe
  199. unsubscribe
  200. Substitute
  201. Select and Count
  202. ERROR: duplicate key violates unique constraint
  203. Issue with copying data from a text file.
  204. Multiple partition tables and faster queries
  205. Encode
  206. Help with sub query
  207. better approach: case or join
  208. triple self-join crawling
  209. Rollback
  210. log file permissions?
  211. Grabbing Newest Records From Duplicates
  212. Fw: INSERT INTO
  213. INSERT INTO
  214. join table with itself?
  215. Alter Table
  216. unsubscribe
  217. unsubscribe
  218. (NONE)
  219. unsubscribe
  220. ordering by multiple columns
  221. Joins on many-to-many relations.
  222. reindex database
  223. How to declare cursor if tablename is a variable?
  224. import CSV file
  225. Re: Maintence DB
  226. Maintence DB
  227. postgres configuration
  228. Re: [ADMIN] [GENERAL] PgAgent logging verbosity
  229. PgAdmin 1.6.2 crashes when resize the collumn
  230. For loop
  231. Re: For loop
  232. Re: A form of inheritance with PostgreSQL
  233. Re: A form of inheritance with PostgreSQL
  234. Re: A form of inheritance with PostgreSQL
  235. Installing with libs of postgresql-libs
  236. how to use a date range in a join
  237. Re: Alternative Serial
  238. There is acid without transactions ?
  239. Re: Statistics
  240. PostgreSQL to Oracle
  241. Re: Statistics
  242. Re: A form of inheritance with PostgreSQL
  243. index not being used. Why?
  244. Fw: CREATE TABLE
  245. Fw: CREATE TABLE
  246. CREATE TABLE
  247. Table inherit & foreign key problem
  248. View Vs. Table
  249. [Re: PRIMARY KEY]
  250. Re: inheritance