Posts by Zilmar • 21 points

• -1

  votes

  1

  answer

  239

  views

  Q: SELECT WITH CAST OR CONVERT TO AN ILIKE USING SEQUELIZE

  I need to do a full-text search using sequelize, but when I place an iLike to search for an element of an integer or date type column, I can’t send a String, as I would a cast to search for that…

  javascript node.js postgresql sequelize-js

  asked 4 years, 1 month ago Zilmar 21

• 1

  votes

  1

  answer

  229

  views

  Q: SELECT with two Foreign key, return the two tables even looking for only one of the keys

  I have a table that has two FK to reference the same table. By selecting all elements that have one of the two FK, using the query: SELECT "Proposta".id, "Proposta".id_segurado,…

  mysql sql database postgresql query

  asked 4 years, 1 month ago Zilmar 21