Search results for query: *

Thanks for your answers! I forgot about this row_number() functions.

I thought so :-) But my problem right now is how does that select statement have to look like?

Would it be possible then to update the table to include a iterative value per ID like ID iteration ... 123 1 ... 123 2 ... 123 3 ... 456 1 ... 456 2 ...

I'm sorry if i was unclear in my original post, but the problem is that item1, item2 could actually be any arbitrary string like 'abc', 'sausage', 'airplane'...

Hi all, i have a table with the following structure: entry_no ID item amount 1 123 item1 2 2 123 item2 1 3 123 item3 3 4 456 item1 1 5 456 item4 4 Now what i would like to achieve is...

Hi everyone, on SuSe 10.2. 64 bit version i get the following error when calling make install: make[3]: Leaving directory `/home/chris/downloads/postgresql-8.2.4/src/port' ./zic -d '/usr/local/pgsql/share/timezone' -p 'US/Eastern' ./data/africa ./data/antarctica ./data/asia ./data/australasia...

Hi all, I tried to configure the scope of some ports for the firewall on my windows 2003 server. What i want to do is to allow access to programs like CVS or VNC and file sharing based on ip address, so I entered the port for CVS for example and changed the scope to xxx.yyy.0.0/xxx.yyy.zzz.0...

Hi everybody, I hope somebody can help me out. Despite having indices on all fields involved in the WHERE clause the query takes just too long: Here's the query: SELECT a.allele_1, a.allele_2, a.snp_id FROM my_table a INNER JOIN another_table b USING (snp_id) WHERE NOT b.snp_id=null AND...

Thanks! That did it!

Hi everyone, instead of executing several queries like SELECT a FROM table WHERE id=1 and SELECT b FROM table WHERE id=2 I would like to combine the queries. I tried already using subqueries like SELECT (SELECT a FROM table WHERE id=1), (SELECT b FROM table WHERE id=2) but without...

Hi everyone, is there a way to get the files that were modified from a certain onwards and copy them to a different folder in order to make a backup of only those files that were modified? Thanks!

Hi, i have a table where i want to store which id occurs in which table, so the table looks basically like this: table_name id t1 1 t1 2 ... t2 150 t2 151 I have been trying to come up with a query that inserst...

Hi everyone! i have a table with around 57 million tuples, with the following columns: pid(varchar), crit(varchar), val1(varchar), val2(varchar). Example: pid crit val1 val2 p1 c1 x y p1 c2 x z p1 c3 y x ... What i am doing is to query...

Hi everyone! i have a table with around 57 million tuples, with the following columns: pid(varchar), crit(varchar), val1(varchar), val2(varchar). Example: pid crit val1 val2 p1 c1 x y p1 c2 x z p1 c3 y x ... What i am doing is to query...

Thanks that worked!!

I tried that but it seems not to work with order by. That's the error i get when i include the order by: SELECT DISTINCT ON expressions must match initial ORDER BY expressions

Hi everyone, i have amongst others the columns pid(varchar) and insertDate(timestamp) and would like to obtain all distinct pid values ordered by insertDate. The problem, though, is that with the following query select distinct pid, insertDate from mytable order by insertDate returns all...

it's switched

Hi everyone, i would like to do the following but don't know how: I want to allow only computers from a certain ip addressto access my windows server 2003, e.g. only computers with ip 123.123.x.x should be able to access the server. Thanks for any hints.

I changed the hosts file and configured the nic. Apparently it helped as at least some of the users experienced improvements. Thanks to everybody!!!