hegemon

Warsaw, Poland

Sep
11
awarded Revival
Sep
4
answered List used PHP modules in code base
Sep
2
answered check cookie if cookie exists
Aug
21
answered javascript onclick function null
Aug
19
awarded Popular Question
Aug
19
awarded Yearling
Aug
19
awarded Teacher
Aug
19
revised Postgresql: datatype for email address
added 71 characters in body
Aug
19
answered Postgresql: datatype for email address
Jul
7
awarded Popular Question
Jun
13
revised Where does the magic column "name" come from?
Added version tag, since the quirk appears to work only in some versions of Postgres.
May
29
comment How to make Chrome remember password for an AJAX form?
This solution works in my app. There's no need to reload whe whole page, only iframe address should change. I've also had to make the target page (blank.html, renamed to blank.php) return a random string to make it work. It' is also wise to use method="post", so that plaintext passwords don't get stored in the server's access log.
May
28
answered Node.js npm install express failed to fetch from registry
May
27
awarded Yearling
May
27
awarded Yearling
May
8
revised Create Alias for PostgreSQL Table
edited body
May
8
comment Create Alias for PostgreSQL Table
In that case you are doomed with triggers or rules, however an upgrade might be easier than implementing those.
Apr
26
answered Create Alias for PostgreSQL Table
Apr
25
comment Looping through a postgres table and returning the wekid
I think the "weekid" can be obtained form date using the following query: select (date_trunc('week', '2014-04-21'::date) + interval '4 days')::date::text; The expression converts any date in the week to last Monday's date, then adds 4 days to advance to Friday (add 5 for Saturday). The result is converted to date and then to string to drop hours from the result./
Apr
25
comment Postgres performs full table scan instead of applying other WHERE clause first
Is it typical for your queries to return no rows? I bet the timing changes when an existing annotation name is selected. Also a question, how many annotation names you have?
1 2 3 4 5