Reputation
16,059
Top tag
Next privilege 20,000 Rep.
Access 'trusted user' tools
Badges
3 29 58
Newest
 Copy Editor
Impact
~1.1m people reached

Aug
27
answered How to use a value from insert in conditional insert in postgres
Aug
27
comment Matching data in two tables
@ypercube: I know that, but it will not work as it is shown right now using o.Cust_ID.
Aug
27
comment Calculating the percentage change from the previous row
There was a Value in the question, not a [Value]
Aug
27
comment Oracle and execution plans
You don't need a procedure for that. Just run the select statement directly.
Aug
27
comment Calculating the percentage change from the previous row
[value] is an invalid identifier ([ or ] or not allowed in an SQL identifier)
Aug
27
revised Determining the specific command type in a DDL trigger
edited tags
Aug
27
revised Is it possible to cascade delete a column value?
edited tags
Aug
27
comment Matching data in two tables
Your query will fail in Postgres: "column "c.cust_id" must appear in the GROUP BY clause or be used in an aggregate function"
Aug
26
comment Postgres Dump and Restore on Linux Terminal
postgresql.org/docs/current/static/backup.html
Aug
25
revised Losing the last column of data
added 24 characters in body
Aug
25
revised SQL Server 2000 Error
edited tags; edited tags
Aug
24
revised How do you calculate how much hardware resources you need for a database?
edited tags
Aug
23
comment Compacting a sequence in PostgreSQL
I have to agree with the others. A generated primary key has no meaning whatsoever. It's only sole purpose is to uniquely identify a row in a table. And it can do that regardless if the key's value is 5,42,3465 or 3623983987436. Renumbering those unique values is nonsense - they still are unique afterwards. So what did you gain? Nothing.
Aug
23
revised PostgreSQL: ERROR: cannot execute CREATE DATABASE in a read-only transaction
edited tags
Aug
21
revised SQL DatabaseMail smtp error 5.7.57 at one site, email works at another with the same details
edited tags
Aug
20
comment How does Postgres make its B-tree index?
Why do you think the wikipedia page describes the implementation of a Postgres B-Tree index and the way Postgres reads those indexes?
Aug
20
comment Oracle DB: Can one db file be shared between table space
If you are dropping the complete tablespace, you don't need to drop the data files because the option and datafiles for the drop tablespace will do that as well. So all you need is step #3
Aug
20
revised Oracle DB: Can one db file be shared between table space
added 43 characters in body
Aug
19
comment What's the quickest way to periodically export PostgreSQL data to a local file on Windows?
But that will create the file on the server not on the client.
Aug
19
comment How does Postgres make its B-tree index?
log_1(2) has nothing to do with the block size. Postgres uses an 8kb block size. That's it. Nothing more, no formulas, no magic, no nothing. One block is 8kb there is nothing more to it. Where do you get the idea that the blocksize is (dynamically) calculated using log_1(2)?