Andomar

Netherlands

Age: 42

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
awarded Citizen Patrol
Feb
5
awarded Yearling
Feb
5
awarded Yearling
Feb
4
comment Rollback the inner transaction of nested transaction
@Endemic: Thanks, you're right! I've updated the answer.
Feb
4
revised Rollback the inner transaction of nested transaction
added 1 character in body
Feb
2
awarded Good Answer
Jan
31
comment Reverse history search in bash followed by arrow keys causes cursor to display at the wrong location
Works great if you enclose only the non-printing sequences in \[ and \] (so you need multiple groups of these block quotes)
Jan
25
awarded Popular Question
Jan
23
awarded database-design
Jan
20
awarded Nice Answer
Jan
12
awarded Notable Question
Jan
11
comment Postgresql INSERT RETURNING complex type
The above works for me and it should work for you. What error message do you get?
Jan
9
comment Check if a group contains all the ids in any of the arrays supplied
If you can use a chosen number like -1 instead of null, you could use user_groups || -1 @> $1[subscript:subscript] to ignore the -1 during matching.
Jan
9
answered Check if a group contains all the ids in any of the arrays supplied
Jan
9
revised Postgres import csv that has one row
added 8 characters in body
Jan
9
comment Postgres import csv that has one row
The csv header option tells Postgres to skip the first row. Try omitting it.
Jan
9
revised Postgresql INSERT RETURNING complex type
[Edit removed during grace period]
Jan
9
answered Postgresql INSERT RETURNING complex type
Jan
9
answered How to upgrade pg_dumpall
Jan
3
answered Need select 2 rows from Table2, which is joined with Table1. See description
1 2 3 4 5