Andomar

Netherlands

Age: 41

I'm a software developer at a telco supporting line-of-business applications. We use a variety of technologies from ASP.NET to Perl. I've come to appreciate SQL more over time, and I now spend most of my time in the database.

If you'd like to learn SQL properly, consider the free SQL course from Stanford. For more free online courses awesomeness, check out the list of courses on Coursera and EdX.

1d
comment PostgreSQL doesn't log
@dezso: That is unlikely... did you test with sudo -u postgres echo hi > /tmp/test.txt? That runs echo as postgres but the redirect as root. The correct syntax is sudo -u postgres bash -c 'echo hi > /tmp/test.txt' and it should show a "permission denied" error.
1d
revised PostgreSQL doesn't log
added 60 characters in body
1d
answered PostgreSQL doesn't log
Jun
25
comment PL/pgSQL: Add static column to query result
Your func2 returns multiple times. In order to sort effectively, you could insert the various rowsets from func1 into a temporary table and return that.
Jun
25
answered PL/pgSQL: Add static column to query result
Jun
23
comment Select @field From table as parameter
Column or table names cannot be parameters. You'd need to set the SelectCommand programmatically.
Jun
22
awarded Guru
Jun
21
comment Is there a way to add a column to a table without affecting performance?
On a busy Postgres system adding a column might never get through. I've had to firewall out all clients to get the exclusive lock required. By contrast, SQL Server blocks new locks until the alter has gone through. Surprisingly different behavior!
Jun
21
revised Best way to insert all combinations of input items
deleted 60 characters in body
Jun
21
comment Bulk insert in SQL Server with a regional separator
bulk insert does not support localized decimal separators. That's very unexpected. When I hit the same problem I spend multiple days trying to figure out what I missed.
Jun
21
comment how to use loop in stored procedure to copy data from one table to another in sql server
Wouldn't recommend running queries from the internet without verifying them yourself. Make a copy of the tables and have a go.
Jun
21
revised how to use loop in stored procedure to copy data from one table to another in sql server
added 677 characters in body
Jun
21
answered how to use loop in stored procedure to copy data from one table to another in sql server
Jun
16
awarded Enlightened
Jun
16
awarded Nice Answer
Jun
15
revised Cannot write XML file with default namespace
deleted 1 character in body
Jun
15
revised Syntax error (missing operator) in query expression ''
added 36 characters in body
Jun
15
revised How to sum the count value?
added 32 characters in body
Jun
14
revised Compared counted data from the same table
added 264 characters in body
Jun
14
answered Compared counted data from the same table
1 2 3 4 5