Skip to content

PostgresSQL Select IN concatenation with date fail #10

@simone

Description

@simone

The output dlelete query seem to be ok, but I think the raprpesentation string of date is different from the database quoteliteral concatenation of the datetime field.

DELETE FROM "composite_basic_article" WHERE quote_literal("headline")||'#'||quote_literal("pub_date") IN (E'''Fourth article''#''2005-07-31 00:00:00''',E'''Default headline''#''2005-07-31 00:00:00''',E'''Article 7''#''2005-07-31 12:30:00''',E'''Article 6''#''2005-07-31 00:00:00''',E'''Area man programs in Python''#''2005-07-28 00:00:00''')

infact this don't delete the right articles

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions