Results 1 to 2 of 2
  1. #1
    Join Date
    Feb 2004
    Location
    Bangalore, India
    Posts
    250

    Unanswered: Date Add In PostgreSql

    hi ther


    i ve a table of the form

    tableA (
    slno integer,
    date1 date
    )

    and another table as

    tableB(
    period1 integer
    )


    what i want is a VIEW which has the "period1" of tableB added to the "date1"
    of tableA

    can ne 1 explain how to create the view


    thanks & regards

    baburaj
    Cheers....

    baburajv

  2. #2
    Join Date
    Apr 2003
    Posts
    23
    huh?! And what about your jonction condition? And why dont you simply use a timestamp instead of an integer?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •