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

Feb
4
awarded  Nice Answer
Feb
4
revised use variable as column name in where clause in sql
edited tags
Feb
4
revised Sleeping queries blocking rebuild index and update statistics job in Always on
edited tags
Feb
4
comment Query gives not result
Additionally: the value 12.99875 from your sample query doesn't show up in your sample data at all. Is that a typo? Using where lon = 12.18625 does work.
Feb
4
comment Query gives not result
double an approximate data type and comparison will not always work the way you think it will: floating-point-gui.de
Feb
4
comment Database Change Management
Have a look at Liquibase. It makes the change process a bit more strict but has proven to be very helpful to us (Teams of 15+)
Feb
3
comment Why would a default constraint be missing an index?
You should show us that query. Maybe it just looks for "non-pk constraints"
Feb
3
revised Querying sums of grouped consecutive rows in PostgreSQL 9
edited tags
Feb
3
answered Querying sums of grouped consecutive rows in PostgreSQL 9
Feb
3
revised Oracle Hot Backup Theory
edited tags
Feb
3
revised sql wiki excerpt
Added a clearer hint that this tag should not be used for questions related to Microsoft SQL Server
Feb
3
suggested approved edit on sql tag wiki excerpt
Feb
3
comment Get TEXT value of a CLOB OID in Postgresql
Did you try loread()? postgresql.org/docs/9.0/static/lo-funcs.html
Feb
3
revised Referential integrity after disable/enable trigger all
added 2 characters in body
Feb
3
revised Connecting from SQL Server 2000 client to SQL Server 2008 Express
There is no DBMS product called SQL2000
Feb
3
comment Update statement with a function
Which DBMS are you using? Postgres? Oracle? What does the execution plan say? Do you have an index on id? How many rows will be updated with that statement? What exactly is fnGetArea() doing?
Feb
3
comment Managing CTE execution order under uncertainty
"it appears as if unique constraints are applied at the sub-statement". Correct, unique constraints are evaluated row by row. You can however work around that by defining the unique constraint as deferred
Feb
2
comment Get TEXT value of a CLOB OID in Postgresql
I think you are looking for lo_get(): postgresql.org/docs/current/static/lo-funcs.html
Feb
2
comment database DDLs and implicit commit
There are many DBMS that support transactional DDL: Postgres, SQL Server, DB2, Firebird, SQLite, Ingres, Informix, Teradata and NuoDB are the ones where I know it for certain. And Postgres certainly does not do an implicit commit when you run DDL. drop table foo; rollback; works just fine (provided you are not running in autocommit mode of course)
Feb
2
comment Foreign Key NULL vs Foreign Key to an empty string
Definitely go for the NULL value. "Magic" values for things like that are usually not a good idea.