PDA

View Full Version : pgsql Sql

Pages : 1 2 3 4 [5] 6 7 8 9 10 11 12 13 14
  1. x-enigmail-version:content-type:content-transfer-encoding;b=VUNY0pEFmQYJLTkBJ83WLcfC/udJo2fTgxrZQg6OqJ3ZZSaWVQTv+PePL+tb58cMYdKZoTDSk0+ AWoQdSfs7h94B+KOkWptEGx8CELQpaQbqDMQFzQiyzHmbTM6wz e0u
  2. SHA-1 vs MD5
  3. tesearch2 question
  4. PRIMARY KEY
  5. best index for ~ ordering?
  6. Inc
  7. Re: Time of executed query
  8. Re: Time of executed query
  9. [Fwd: View Vs. Table]
  10. Selecting exactly one row for each column value
  11. Re: convert to a string
  12. convert to a string
  13. Re: Time of executed query
  14. GiST index question: performance
  15. How to return a select query
  16. Select when table have missing data
  17. Re: How to store a password encripted in a user defined table
  18. Re: pg_dump inquiry
  19. Re: How to store a password encripted in a user defined table
  20. column definition list of a dynamic record argument
  21. How to store a password encripted in a user defined table
  22. Re: [GENERAL] Esay question, about the numeric format
  23. what is the best way to get key information in postgres?
  24. unsubscribe
  25. Case with Char(1)
  26. Conditional NOT NULL constraint
  27. How to union table without union statement?
  28. unsubscribe
  29. Re: Change the Default Database
  30. Re: Position of a field
  31. =?WINDOWS-1252?Q?Syntax_Error_in_COPY_when_=93create_functio n=94?=
  32. Re: Change Default Database
  33. Re: Change Default Database
  34. getting at sequence previous/next values
  35. Re: Change Default Database
  36. Re: Change Default Database
  37. Re: Insert based in a select
  38. Very large IN-clause is slow, but how to rewrite it?
  39. Re: Change a field to sequence (serial)
  40. Insert based in a select
  41. selecting random row values in postgres
  42. how do I to generate a sequence Range or Set of integer constants
  43. simple web search
  44. Re: DISTINCT ON not working... RESOLVED
  45. pg_dump fails (timestamp out of range)
  46. Re: [GENERAL] Esay question, about the numeric format
  47. How compare current_setting(..) ?
  48. Problems with temp table and PL
  49. how to generate a list of distinct scalar values from a column which type is array
  50. Problem with Temp Table and Result Set from PL Function...
  51. DISTINCT ON not working...?
  52. cartesian product
  53. Uppercase and Lowercase
  54. unsubscribe
  55. sub-limiting a query
  56. ordering of selected rows from an ordered subselect
  57. Debug (is it PostgreSQL?)
  58. There is a different cast than ::MyOtherType() ?
  59. Retrieving 'Credit' when 'C'
  60. "for SELECT DISTINCT, ORDER BY expressions must appear in select list" - is that the standart or a limitation of postgresql?
  61. problem with join
  62. can someone explain confusing array indexing nomenclature
  63. Regaring posting a query
  64. (NONE)
  65. Re: COPY FROM query
  66. Re: [ADMIN] Deadlock on transaction
  67. Re: [ADMIN] Deadlock on transaction
  68. Re: [ADMIN] Deadlock on transaction
  69. Sum sets of records
  70. Re: COPY FROM query.
  71. COPY FROM query.
  72. unsubscribe
  73. alias not applied
  74. dynamic sql
  75. unsubscribe
  76. unsubscribe
  77. huge disparities in =/IN/BETWEEN performance
  78. Re: COPY FROM - force a value
  79. unsubscribe
  80. COPY FROM - force a value
  81. Re: metaphone and nysiis in postgres
  82. Open a Transaction
  83. unsubscribe
  84. unsubscribe
  85. unsubscribe
  86. unsubscribe
  87. Re: Seeking quick way to clone a row, but give it a new pk.
  88. question on passing parameter in sql query
  89. Odd PL/PgSQL Error -- relation "X" does not exist when using indexexpression
  90. Seeking quick way to clone a row, but give it a new pk.
  91. Re: metaphone and nysiis in postgres
  92. Re: metaphone and nysiis in postgres
  93. metaphone and nysiis in postgres
  94. interval as hours or minutes ?
  95. Removing duplicate rows
  96. Re: Index ANDing & Index ORing
  97. Re: Index ANDing & Index ORing
  98. Re: sql
  99. PL/pgsql declaration of string / bit / number with given (variable!)length
  100. Getting associated columns with max() without subquery
  101. Re: Insert into a date field
  102. sql
  103. Re: Index Anding
  104. Search a range of cases/records
  105. Compilation Error AIX
  106. Compilation errors
  107. Re: Index Anding
  108. Index Anding
  109. Index ANDing & Index ORing
  110. Question regarding multibyte.
  111. Re: Nocount and scope_identity()
  112. to_chat(bigint)
  113. Nocount and scope_identity()
  114. Duplicate records
  115. Insert into a date field
  116. Insert Data and autonumeric field
  117. Re: Compilation Error AIX
  118. Re: Index Anding
  119. Log, Logs and more Logs
  120. Arrays, multidimensional ANY (v 8.2)
  121. Differentiate Between Zero-Length String and NULL Column Values
  122. Very strange postgresql behaviour
  123. Re: [NOVICE] Windows 2K Installation difficulties...
  124. Function returning SETOF using plpythonu
  125. Evaluate a variable
  126. implementing (something like) UNIQUE constraint using PL/pgSQL
  127. Intersection of two date interval
  128. LEFT Join Question
  129. Re: shared_buffers and shmall,shmmax
  130. shared_buffers and shmall,shmmax
  131. Re: shared_buffers and shmall,shmmax
  132. Looping recordset
  133. Using Temporary Tables in postgres functions
  134. Operators and aggregates for arrays
  135. Odbc configuration on Localhost
  136. How to query by column names
  137. Schema sample
  138. FW: Possible to emulate pre-8.2 behaviour of SET CONSTRAINTS?
  139. list variable attributes in one select
  140. Possible to emulate pre-8.2 behaviour of SET CONSTRAINTS?
  141. Changing point for commas and commas for point
  142. select based on multi-column primary keys
  143. Permissions Query?
  144. Re: Query to return schema/table/columname/columntype
  145. Query to return schema/table/columname/columntype
  146. Help ... Unexpected results when using limit/offset with select statement..DB corruption?
  147. Some help with functions-syntax
  148. Postgresql & Oracle Heteregenous services - strange behaviour
  149. Update query by joining multiple tables.
  150. Re: Droping indexes RESOLVED
  151. Removing CONTEXT message
  152. Re: Droping indexes
  153. Re: Droping indexes
  154. Droping indexes
  155. Removing CONTEXT message
  156. Referencing tables are grinding UPDATE to a halt
  157. vacuum process taking more than 33 hours
  158. Standard function not found ?
  159. update query taking 24+ hours
  160. Re: deleting records from a table
  161. deleting records from a table
  162. Conditional SQL Query
  163. Aggregating both tables in a join?
  164. a way to generate functions dynamically ?
  165. How to aggregates this data
  166. Requirement for PostgreSQL Database Developer
  167. Question about GUI
  168. Re: Table relationships
  169. Table relationships
  170. Help with Array
  171. MI5 Persecution: Security Service Tribunal Denies
  172. how un-suscribe from this list
  173. quoted variables in pgsql
  174. MI5 Persecution: Communications with Security Service Tribunal in 1999
  175. Comparing date using a very strange table structure
  176. MI5 Persecution: Eye Say, and Lord Gnome Answers
  177. MI5 Persecution: Counter-surveillance sweep by Nationwide Investigations Group
  178. Re: [SQL NOTIFY Help] sending NOTIFY to the external program
  179. Re: [SQL NOTIFY Help] sending NOTIFY to the external program
  180. [SQL NOTIFY Help] sending NOTIFY to the external program
  181. Schema and Function names
  182. or function
  183. domains and serial
  184. I would like to alter the COPY command
  185. How to reduce a database
  186. Help in altering the column lenght
  187. Re: help with version checking
  188. help with version checking
  189. Unable to drop table, error mentions "reltriggers"
  190. Related tables to a view
  191. Changing character set when the damage is done
  192. join/group/count query.
  193. Fetching BLOBs
  194. Help with quotes in plpgsql
  195. Desc table
  196. Query a select that returns all the fields of an specific value of primary key without knownig the name of the single column's primary key?
  197. Res: SELECT with WHERE clause by column number
  198. SELECT with WHERE clause by column number
  199. Requirement for PostgreSQL Database Developer
  200. fetching & Merging BLOB
  201. Unions and Grouping
  202. Re: Need to subtract values between previous and current row
  203. Need to subtract values between previous and current row
  204. Query Help
  205. join a lot of columns of two tables
  206. Rule for multiple entries
  207. join and sort on 'best match'
  208. Finding gaps in scheduled events
  209. TPCH Benchmark query result invalid
  210. subquery abnormal behavior
  211. Problem with SQL stored procedure
  212. Re: Problem with SQL stored procedure
  213. could not find pathkey item to sort
  214. INSERT DELETE RETURNING
  215. Type casts with arrays
  216. Re: Proper way of iterating over the column names in a trigger function. [ SOLVED]
  217. Query is fast and function is slow
  218. Count field in query
  219. Proper way of iterating over the column names in a trigger function.
  220. I don't want receive more emails
  221. Can someone explain the problem with this select
  222. Question about "AT TIME ZONE"
  223. transaction in function
  224. null values in non-nullable column
  225. Using Control Flow Functions in a SELECT Statement
  226. Query for block updates
  227. Re: Query for block updates
  228. Re: hi any one can help me
  229. hi any one can help me
  230. Tracking Down Error in Stored Procedure
  231. Re: Tracking Down Error in Stored Procedure
  232. Problem inserting composite type values
  233. calling elog possibly causing problem in DirectFunctionCall1
  234. Setting boolean column based on cumulative integer value
  235. Set binary column dependent on cumulative value of integer column
  236. retrieve row number
  237. Select (1-3)
  238. pg_xlog on separate drive
  239. Re: pg_xlog on separate drive
  240. Autovaccum
  241. SQL command join question
  242. Re: SQL command join question
  243. Re: SQL command join question
  244. Re: SQL command join question
  245. Subselects in CHECK clause ...
  246. Re: Subselects in CHECK clause ...
  247. consistent random order
  248. Re: consistent random order
  249. Re: consistent random order
  250. Auto-Response: Re: UNICODE and PL/PGSQL