Skip to content

Syntax doesn't work as expected #12

Open
@leoosalles

Description

@leoosalles

On page 51 the author introduces an example of COALESCE() function. But it doesn't work. I mean, there are still NULL fields.
Here is the statement:

SELECT * FROM station_data
WHERE coalesce(precipitation, 0) <= 0.5;
coalesce

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