PDA

View Full Version : pgsql Sql

Pages : 1 2 3 4 5 6 7 8 9 10 11 12 13 [14]
  1. Accessing objects over db-borders
  2. Re: Determining Rank
  3. Re: Determining Rank
  4. Re: [despammed] Accessing objects over db-borders
  5. Re: problem while converting sybase quries to postgres
  6. Re: pg primary key bug?
  7. Re: pg primary key bug?
  8. Re: problem with postgres
  9. pg_restore problem
  10. Re: pg_restore problem
  11. Re: MSSQL versus Postgres timing
  12. Re: MSSQL versus Postgres timing
  13. error in function!!
  14. Re: BLOBs vs BYTEA
  15. Re: MSSQL versus Postgres timing
  16. Re: MSSQL versus Postgres timing
  17. Re: MSSQL versus Postgres timing
  18. Re: MSSQL versus Postgres timing
  19. BLOBs vs BYTEA
  20. Re: [PERFORM] OFFSET impact on Performance???
  21. Re: case sensitive/insensitive confusion
  22. Re: Need SELECT rights to UPDATE/DELETE WHERE?
  23. Re: case sensitive/insensitive confusion
  24. Re:
  25. plpgsql functions and NULLs
  26. Function Doubt
  27. plpgsql select into with multiple target variables
  28. error: cast the timestam expression
  29. What's the equivalent in PL/pgSQL
  30. Re: plpgsql select into with multiple target variables
  31. Rule problem with OLD / NEW record set
  32. Re: Function Doubt
  33. calling JAVA UDF through trigger
  34. (NONE)
  35. Re: error: cast the timestam expression
  36. Re: error: cast the timestam expression
  37. Calendar Function
  38. Re: contrib/intarray doc/tutorial needed
  39. Re:
  40. hardware mod based on feedback from the list
  41. Re: What's the equivalent in PL/pgSQL
  42. Hardware for best performance was same question little different test MSSQL vrs Postgres
  43. URL activation through trigger
  44. Re: hardware mod based on feedback from the list
  45. Re: [GENERAL] Foreign Key relationship between two databases
  46. Re: What's the equivalent in PL/pgSQL
  47. Re: Moving from Transact SQL to PL/pgsql
  48. Constraint on 2 column possible?
  49. Re: Constraint on 2 column possible?
  50. Re: Complete instruction in a trigger
  51. Complete instruction in a trigger
  52. Re: Complete instruction in a trigger
  53. Re: same question little different test MSSQL vrs Postgres
  54. Re: same question little different test MSSQL vrs Postgres
  55. working with multidimensional arrays in plpgsql
  56. Re: working with multidimensional arrays in plpgsql
  57. Re: How to find out programmatically whether a query on a view will use an index?
  58. Re: working with multidimensional arrays in plpgsql
  59. Re: ***SPAM*** Re: same question little different test MSSQL
  60. Re: same question little different test MSSQL vrs Postgres
  61. Re: same question little different test MSSQL vrs Postgres
  62. Re: same question little different test MSSQL vrs Postgres
  63. Re: update from multiple rows
  64. Sorry I see my first question did not get posted (maybe because of the attatchments)
  65. same question little different test MSSQL vrs Postgres
  66. private table
  67. Re: converting Oracle scripts to PostgreSQL
  68. Moving from Transact SQL to PL/pgSQL
  69. Moving from Transact SQL to PL/pgsql
  70. Looking up table names by REFERENCES
  71. difficult JOIN
  72. Re: converting Oracle scripts to PostgreSQL
  73. Re: "How do I ..." SQL question
  74. datediff is there something like it?
  75. How to find out programmatically whether a query on a view will use an index?
  76. Value specific sequences?
  77. Re: How to find out programmatically whether a query on a view will use an index?
  78. Re: How to find out programmatically whether a query on a view will use an index?
  79. Invalid Input syntax for type bigint
  80. How to update dependent tables AND design considerations
  81. editors with colum positioning for debugging?
  82. Question about a select
  83. update from multiple rows
  84. testing/predicting optimization using indexes
  85. Re: still having pg_user error
  86. returning a record from PL/pgSQL
  87. still having pg_user error
  88. automatic table locking on too many locked records?
  89. Re: ERROR: row is too big: size 9856, maximum size 8136
  90. Re: ERROR: row is too big: size 9856, maximum size 8136
  91. Re: pg_user relationship does not exist
  92. OID's
  93. Re: OFFSET impact on Performance???
  94. Re: Problem on Geometric functions
  95. Re: SQL timestamp to date cast
  96. include in both ecpg and C++
  97. Query performance and understanding explain analzye
  98. ERROR: row is too big: size 9856, maximum size 8136
  99. Re: Returning a bool on DELETE in a proc.
  100. Conversion ideas (Views/procedures)
  101. Re: Looking for examples of S/P
  102. Re: Returning a bool on DELETE in a proc.
  103. Looking for examples of S/P
  104. URGENT: Using function inside query
  105. postgres stored procedures
  106. Re: Returning a bool on DELETE in a proc.
  107. Re: Returning a bool on DELETE in a proc.
  108. Re: query configuration for validate empty quote to zero
  109. mail + rfc822, rfc2822 + schema
  110. "How do I ..." SQL question
  111. query configuration for validate empty quote to zero
  112. Inserting or Deleting conditionally
  113. plpgsql and for with integer loopvar error
  114. Re: Inserting or Deleting conditionally
  115. Re: Record type in sql
  116. Record type in sql
  117. Re: TEXT type blob extraction in ecpg
  118. Re: pgmirror
  119. SQL design question: null vs. boolean values
  120. Re: return value of the trigger function
  121. Re: SQL Query Performance tips
  122. I am writing a MS SQL server conversion utility and am having an issue with timestamp
  123. assign the row count of a query to a variable
  124. Re: Column with recycled sequence value (solved (somehow))
  125. Re: Column with recycled sequence value
  126. Trick to 'run' a view on two databases and combine the result ?
  127. pgmirror
  128. Problems with Quotes
  129. Column with recycled sequence value
  130. Re: Column with recycled sequence value
  131. Re: Column with recycled sequence value
  132. Re: Problems with Quotes
  133. Re: Parsing a Calculation from a field
  134. Re: Problems with Quotes
  135. Re: Single row tables
  136. failed to find conversion function from "unknown" to text
  137. Implementing queue semantics (novice)
  138. Re: Single row tables
  139. Re: failed to find conversion function from "unknown" to text
  140. Single row tables
  141. Re: Single row tables
  142. Re: Syntax error while altering col-type
  143. Re: Syntax error while altering col-type
  144. Re: Implementing queue semantics (novice)
  145. Syntax error while altering col-type
  146. Problems with HAVING
  147. Re: failed to find conversion function from "unknown" to text
  148. Re: Syntax error while altering col-type
  149. Re: Syntax error while altering col-type
  150. Columns into rows.
  151. RE RE: Single row tables
  152. Re: Columns into rows.
  153. Re: Problems with HAVING
  154. Re: Problems with HAVING
  155. Re: Problems with Quotes
  156. Recursive query to be used in another result ?
  157. Re: Syntax error while altering col-type
  158. Re: Problems with Quotes
  159. Re: Problems with HAVING
  160. Re: Syntax error while altering col-type
  161. Re: Problems with Quotes
  162. Simple Question
  163. Re: Simple Question
  164. Parsing a Calculation from a field
  165. TEXT blob extraction in ecpg
  166. Easier way to 'strip' on multiple matches?
  167. Question about insert/update RULEs.
  168. simulating row ownership
  169. View with Union and update rule - fails
  170. vararg plpsql function
  171. plpsql function problem
  172. undigested email
  173. Re: foreign key problems
  174. Calling a table residing in another database from Plpgsql
  175. Re: foreign key problems
  176. one table being used for two purposes with foreign key for each?
  177. Re: Function in C++
  178. Formatting an Interval
  179. Making a prepared statement in a stored procedure
  180. Making a prepared statement in a stored procedure
  181. Problem with subquery containg GROUP BY
  182. simulating global temp tables in plpgsql functions
  183. Get current trasanction id
  184. Re: commit inside plpgsql function
  185. commit inside plpgsql function
  186. save sql result to file
  187. Re: commit in plpgsql function?
  188. commit in plpgsql function?
  189. linux clusters and pgsql
  190. Date datatype
  191. I'm stumped
  192. Question about geometric function area()
  193. Revoke on all database
  194. diff databases
  195. Updating column to link one table to another
  196. Re: Table History
  197. Re: can't get the order I want after inserting new rows
  198. sql can i substitute
  199. can't get the order I want after inserting new rows
  200. Table History
  201. plpgsql.. SELECT INTO ... WHERE FIELD LIKE
  202. get branches & childs from database
  203. question about index
  204. Query aid
  205. Breadth first traversal in PLSQL (How to implement Queue?)
  206. [Fwd: Majordomo results: unsubscribe]
  207. Join issue?
  208. Join issue?
  209. Similar tables, different indexes performance
  210. postgressql.org
  211. mysql set datatype
  212. Hide schemas and tables
  213. Re: Unresolved external: tgetent
  214. Re: parse error at or near "(" -- Huh???
  215. Re: parse error at or near "(" -- Huh???
  216. Re: Insert successful but data not found
  217. Re: Cast NULL into Timestamp?
  218. PREPARED STATEMENT
  219. Re: Cast NULL into Timestamp?
  220. Re: Cast NULL into Timestamp?
  221. Re: Cast NULL into Timestamp?
  222. replacing mysql enum
  223. filtering
  224. Create Calendar