Node: "Postgre: Select rows from a table" problem: the operator > 、 >= 、< or <= can not be used in character columns comparison.It can only use to compare number column

Questions
1

Node: “Postgre: Select rows from a table” problem: the operator > 、 >= 、< or <= can not be used in character columns comparison.It can only use to compare number column.

image
image1430×601 41 KB

1 Like
4

Use the “Execute Query” node (recommended)
This node allows you to directly write SQL without any restrictions imposed by n8n.

Avoid using the “Select rows from a table” node for alphabetical comparisons.

Use the “Execute Query” node when you need more control over the SQL, including string comparisons.

PostgreSQL allows string comparisons using <, >, >=, and <= lexicographically (alphabetically).

1 Like
5

I try it. Thank you very much.