Oliveiros,
I think it's time to give some more details about my task. I will start with
the begining :)
I have a "log" table which stores the dates when users send messages
with a theme from their mobile phone. This table is named
sent_messages and looks like this:
receiver | theme
On þri, 2007-06-05 at 23:55 -0700, Drew wrote:
> I'm having troubles using multiple OUTER JOINs, which I think I want
> to use to solve my problem.
>
> My problem is to find all non-translated string values in our
> translations database, given the 4 following tables:
>
> SOURCE (source_id PR
Drew wrote:
This seems to me the appropriate situation for using OUTER JOINs, but I
cannot figure out how to get the null rows without the not-null rows.
However, when I try to exclude the one not-null row, doing this:
SELECT
s.source_id,tp.translation_pair_id,t.translation_id,t.language_i
Thanks! That was it.
Drew
On Jun 6, 2007, at 1:45 AM, Ragnar wrote:
On þri, 2007-06-05 at 23:55 -0700, Drew wrote:
I'm having troubles using multiple OUTER JOINs, which I think I want
to use to solve my problem.
My problem is to find all non-translated string values in our
translations datab
Hi,
chester c young wrote:
has anyone done any work on comparing schemas?
There are two different projects called 'pgdiff', you'll find them with
google.
I'm trying to automatically propagate changes in a master schema to
child schemas. All schema changes will originate at master. Curren
I found my problem. I attaches an .sql file with my tables, data
and my new query. If you are interested you can take a look.
Thanks to all.
Regards,
Loredana
I forgot the attachement :)
On 6/6/07, Loredana Curugiu <[EMAIL PROTECTED]> wrote:
I found my problem. I attaches an .sql file with my tables, data
and my new query. If you are interested you can take a look.
Thanks to all.
Regards,
Loredana
CREATE TABLE reminder_services (
uid S
Kristo Kaiv escreveu:
oneliner:
select date_trunc('month',now()) + ((8 - extract('dow' from
date_trunc('month',now()))||'days')::text)::interval;
There is a problem when first monday is 1st or 2nd day of month.
bdteste=# SELECT date_trunc('month',meses) + ((8 - extract('dow' from
date_t
true, didn't test it that thoroughly: mod 7 should be bit more beautiful
select date_trunc('month',now()) + ( ((8 - extract('dow' from
date_trunc('month',now()))%7) ||'days')::text)::interval;
On 06.06.2007, at 18:54, Osvaldo Rosario Kussama wrote:
Kristo Kaiv escreveu:
oneliner:
select da
